Hi,
I have a salary spreadsheet with employee no, Cost Centres, name and various salary costs, and total salary. I am using a pivot table to sum up all the cost centre costs in another spreadsheet. I then create spreadsheet for each cost centre, showing employee no, cost centre, name, and...