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.

 

[Ralajer]

Your problem seems, from you wrote, to be solvable. I or any other contributor would have to see the spreadsheet or have its structure adequately described to develop a solution. I would prefer the former so please upload it and link to it.

 

[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.

Does that work for you?

 

[JoeSalmi]

Peter, per your other post in the other thread I am sorry, I did not post it twice but somehow it was. Thank you for locking it. If you have the ability could you please delete it. There is no reason it needs to clog up servers or waste users time.

 

[JoeSalmi]

Ralajer, give me just a moment and I will add a link to the thread. I think that will be easier then sending it to each person.

 

[JoeSalmi]

Ralajer, give me just a moment and I will add a link to the thread. I think that will be easier then sending it to each person.

Sorry it took so long, work is really busy at the moment.

Here is a link. Any help would be greatly appreciated.

https://docs.google.com/leaf?id=0B9...YjcyZi00YWMyLWI0YWUtODdkZDlhZWI1NzAw&hl=en_US