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.

Thanks Roy

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.

Ozgrid Monthly data.xlsx

Hi rory, the same column, cheers

HI, how do I add a calculated field (column) after each Pass/Fail with the percentage result. I need it for all 8 items, 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.

Hi, how do I add a calculated field (column) after each Pass/Fail with the percentage result. I need it for all 8 separate items, cheers.

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.

ozgrid.com/forum/core/index.php?attachment/1229194/

royUK , I put the wildcard back in after Disagree*, and it worked so far. Is that correct.... I need the *.

Hi royUK , the code runs but no results appear. "Disagree" is lower case in the data and my Disagree is lower case in the code, is there something else I need to do? Cheers