OK I made some changes to the spreadsheet so that there are cells to copy for each of the ones on the summery sheet. What would work is to just have it with 50 blank tabs that we could name with jobs. We have never had more than 50 so that should be enough. I also made a word document that has the cells that need to be copied form the Tabs to the summery sheet. I made a list for the first two lines.
Let me know if this helps in understand what I need to do.
Thanks for helping me with this.
Ronnie
|