Hi, just wondered if anyone can help, or even confirm if I can do what I want to do! I've got a spreadsheet where one worksheet contains a template showing work a maintenance contractor has to do (down to an asset level), including the staff that do the work. On the second worksheet I've done a pivot table to show a higher level of information, which removes individual asset information and just shows the amount and type of work that is required at one place.
I've then added in 52 columns to represent the number of weeks in a year to highlight what week particular work will take place to the right of the pivot table. However, if we select one type of work in the pivot table and then highlight the cells in the relevant weeks, when we "select all" again in the pivot table, the cells we've highlighted are in the wrong rows against the wrong type of work.
One way I've found to solve this is to copy the pivot table and paste (values only) - this removes the pivot table link and then everything works as one big table and all is fine. However I don't want to lose this pivot table link because if any changes are made to the maintenance schedule, all these can flow through from the template worksheet.
Is there anyway I can keep the pivot table and link it to the rest of the worksheet? I've attached an example which will hopefully make sense of what I've written, including my workaround.
Thanks
Emma
Bookmarks