Forum

Hi, What add-ins have you got installed in Excel on the PC that crashes? Even removing and reinstalling Office will not guarantee removal of add...

Hi Jihad, Welcome, please read this As Purfleet said, can you please add a clear explanation of what you are trying to achieve. I do not unde...

Hi Andy, Where did you get this code? Did you get that workbook like that? It's a bit messy! There are 4 modules and 3 Subs with the same name...

Hi Andy, no not really. Do you already have code for this? Phil

yes plz. If you can create a PT with the same structure, but without the private data, I think that'll be enough.

Hi Oscar, Please read the forum rules You don't need to click on the 'Quote' button, it just clutters up the thread and I delete the quoted te...

Hi Milly, How do you have duplicate columns? This article may help you Regards Phil

Hi Oscar, have you looked at the Conditional Formatting rules in my workbook? Home Tab -> Conditional Formatting -> Manage Rules Make s...

Hi Declan, If you can supply your workbook I'll try writing the necessary VBA. It shouldn't take too long as it'll be a modification of the code f...

Hi Oscar, You can't make words appear in a pivot table like that, but you can use conditional formatting to highlight negative months where the pre...

.

Hi Eva, You need to lay the data out in a tabular format with numeric values for the things you want to count. If you look at the attached file ...

Hi Manfred, I'm having trouble visualizing this without the data. Can you please supply your workbook with some sample data. Regards Phil