Forum

Why do you have so many blank rows in you data? that makes sorting difficult. Having said that, you could add a couple of helper columns to separat...

If the images are stored in a folder on the PC on which the code works, then, sure the code can find and insert the images. If, however, another PC...

You still have the $ (P$4), so you formula will always reference That cell no matter how far you copy the formula down. Try doing as Catalin sugges...

No file attached. After clicking "Add File" and selecting required file you need to click the "Start Upload" button.

You're welcome. Let me know if there are any specific parts of the code for which you need clarification.

Here is an improved version, which does away with the "Search" button. Select either First Name or Last Name from the relevant combobox lists, if F...

Thanks, Velouria. That is good to know.

No idea why, here is the file again

Attached is a file where I have made a quick UserForm, it should be a good starting point for you. The file could be further enhanced by adding "Us...

Try this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$B$9" Then Target = UCase(Target) End Sub

I think the only way is for you to add a sheet that is formatted just as you require but with no data, to act as a template for new sheets when requir...

It works great! I am attaching a screenshot of the actual dashboard. At the moment there is limited data (and most "expenses" is dummy data).

Many thanks. My actual file can have up to 7 Events per Year and 4 years. So the chart will fill up pretty quickly of all slicers are cleared. That...

You are right, of course. Thanks