Hi,
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.
Any ideas???
Alan
Ps I need about 35 out of 600 businesses
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.
Any ideas???
Alan
Ps I need about 35 out of 600 businesses