I have a spreadsheet that is pretty well completed and has worked well for me for the past 1.5 years but I recently came across a problem that has restricted me from using it to it's full potential. I was wondering if someone could give me a hand in correcting this issue.
I have not uploaded the SS just yet but I wanted to explain what I have and what I am looking for.
The SS I have has a "main page" which displays all the employee's hours and jobs along with all the total hours. It also has several employee pages worksheets that are all exactly the same so main page can grab all the data from the same cells on all the worksheets.
My issue is I originally planned to have no more then a max of 27 work items but have recently come across a job that requires me to have more.
If I add a line on the main page it screws up all the data on the employee pages because I have cells under the actual employee time sheets (workbook).
Is there a way that I can create new lines to the main page and have them added to the employee pages as well with out messing up the spreadsheet?
Let me know if you want a copy of the SS and I will upload it to the web.
I have not uploaded the SS just yet but I wanted to explain what I have and what I am looking for.
The SS I have has a "main page" which displays all the employee's hours and jobs along with all the total hours. It also has several employee pages worksheets that are all exactly the same so main page can grab all the data from the same cells on all the worksheets.
My issue is I originally planned to have no more then a max of 27 work items but have recently come across a job that requires me to have more.
If I add a line on the main page it screws up all the data on the employee pages because I have cells under the actual employee time sheets (workbook).
Is there a way that I can create new lines to the main page and have them added to the employee pages as well with out messing up the spreadsheet?
Let me know if you want a copy of the SS and I will upload it to the web.
