Advanced help needed VBA

[JoeSalmi]

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.

 

[jbeaucaire]

If you click on the first sheet tab, then SHIFT-click on the last tab, you have selected all the tabs at once, or "grouped the sheets" as it is called.

Now most anything you do on the first sheet is duplicated on the on other sheets. So insert 5-10 rows there and the same blanks rows are added in the same place on the other sheets, shifting everything down equally.

 

[shg]

Duplicated at http://www.mrexcel.com/forum/showthread.php?t=575052

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.