I'm after copying values from pivot table to another workbook that just in a normal table and want to separate the values
Into different sheets.
I Hav a pivot table in a workbook. It contains lots of businesses that show expenses (8 of them) for each one I want to copy values of a selected few. Each businesses is a 4 digit number Eg 1189. Want to coy them tp another workbook. ?? The table uses a data validation in cell C4 to filter the exemses to that business.???
Into different sheets.
I Hav a pivot table in a workbook. It contains lots of businesses that show expenses (8 of them) for each one I want to copy values of a selected few. Each businesses is a 4 digit number Eg 1189. Want to coy them tp another workbook. ?? The table uses a data validation in cell C4 to filter the exemses to that business.???
