Thanks Jerry
Posts by cobber1418
-
-
royUK, it does work, I was only applying it to the first column in the rows. I applied it to the column headings and Items and it works great. Thanks again and sorry for the confusion, cheers.
-
-
They all get the data individually from a report. I'll keep checking your other suggestion, cheers.
-
Unfortunately a lot of people will be using it, so not an option, cheers.
-
Actually royUK , after I removed more data the column disappeared again. I did both your suggestions.
-
Thanks Roy, the first one worked, cheers.
-
Hi, how do I prevent columns disappearing in the pivot table if the new data does not have data that was in the column previously. I want the pivot table to keep all the columns regardless if the new data does not have all the previous data, cheers.
-
Thank you very much, cheers.
-
Thanks rory, works great. I assume I also need to insert iferror or something to prevent the below happening when the cells are empty, cheers.
-
Hi rory, see below with the percentage column added, that is what I want to do with a pivot table. I have attached a workbook, cheers.
-
Hi rory, the same column, cheers
-
-
Hi MY, I thought I was in 'Excel General' forum.....thanks anyway.
-
Hi MY, I'm not using VBA....I wanted to just setup the pivot table manually using the Fields, Items & Sets box. Thanks anyway.
-
-
Thanks royUK . How do I mark the thread as "Resolved"
-
Thanks Rory
-
royUK , I have a separate macro for each column. I have attached a sample, cheers.
-
royUK , I put the wildcard back in after Disagree*, and it worked so far. Is that correct.... I need the *.