Automatically updating summary sheet

[maximpinto]

Hi,
Please find attached my excel
I have tabs ranging from RA to DW
Also a summary sheet. As of now i have manually copied data from each tab onto summary sheet
Is there a way to automate the summary sheet so that when i enter data in each tab it gets updated automatically in summary sheet as well

Flexibility needed is:

If row is added in any sheet from RA to DW then the same should be created in summary
IF a resource is added in any tab then the same should be added in Summary.
Similary for delete too

Overall i should be able to update summary automatically when i update the tabs.
Please let me know if this can be done
Thanks

[JBeaucaire]

In my opinion your designing this backwards. Think of the "summary" as more of "database"...the sheet where you enter your information.

Then the OTHER sheets pull their data from the database and show only the info relating to their sheet.

If you DON'T want to do that, I might suggest putting a macro on your Summary Sheet that copies all the data from the other sheets to the Summary anytime you want an updated report. We could even make it occur automatically each time you Click on the SummarySheet to view it.

[royUK]

Why bother? All data should be entered into the "summary sheet", then use AutoFilter to display specific data for perhaps systems.

[maximpinto]

No actually data for each tab comes from diff managers so i wanted it to be reflected in summary sheet when i simply copy whatever data i have received from each manager and copy it in each tab.

I feel this point of yours is what i am looking for
"If you DON'T want to do that, I might suggest putting a macro on your Summary Sheet that copies all the data from the other sheets to the Summary anytime you want an updated report. We could even make it occur automatically each time you Click on the SummarySheet to view it"

Data filter i dont want to use but i was thinking this way too to be easier, and my efforts are reduced

Can this be achieved please help me
Thanks
max

[JBeaucaire]

After looking at your sample sheet more closely, you've got some fancy formatting going on in the X X X sections. I can't figure that one right now...it's late here...

[royUK]

Tis should combine all the sheets to one

Please Login or Register  to view this content.

[maximpinto]

I tried using this code but no the data is coming in summary sheet one below another for each group, not as expected

[maximpinto]

After looking at your sample sheet more closely, you've got some fancy formatting going on in the X X X sections. I can't figure that one right now...it's late here...

Would u be able to look at that
XXX is nothign but those resources who have worked on taht project are marked

Thanks

[royUK]

I tried using this code but no the data is coming in summary sheet one below another for each group, not as expected

What do you mean, it adds the data from each sheet, is this duplicating because the individual sheets aren't cleared each time?

[maximpinto]

no this is how i get it
but not as expected gives headers each time, i want it the original way i ahd sent, all resources in one row
I am not abel to attach the sheet but if u apply that code u can observe it working

[royUK]

Your headers are in Row 2 so a slight amendment

Please Login or Register  to view this content.

[maximpinto]

this eliminates but i am not getting resource names now

[royUK]

What resource names/ The data from each sheet should be copied without the header row

[JBeaucaire]

Roy, take a look at his example "results" desired and scroll off to the right. It's not a simple case of "copy all the data rows" like we normally see. He's got some crazy design that add the names from each sheet at the end of the names from the previous sheet, then copies the "X X X" section OUT further than where it really came from so the names line up on the Summary. Also, some fancy coloring/striping there as well.

That's why I didn't try at 2am, that's a lot more work than he even realizes.

[maximpinto]

Please let me know if this can be done or not

[royUK]

I've finished with this one, several replies not one word of thanks.

[maximpinto]

Dear Roy,
I dont understand, if you have finised i did not get the sheet,
well all i have track as it shows in forum is Jb.. suggestions which is last

"Roy, take a look at his example "results" desired and scroll off to the right. It's not a simple case of "copy all the data rows" like we normally see. He's got some crazy design that add the names from each sheet at the end of the names from the previous sheet, then copies the "X X X" section OUT further than where it really came from so the names line up on the Summary. Also, some fancy coloring/striping there as well.

That's why I didn't try at 2am, that's a lot more work than he even realizes.
"

AFter this if you hav attached pleas do let me know, i am not albe to see any replies. Your last reply was about headers but that is not solving my problem.
I appreciate your efforts
and if you see my last post i had reminded if this can be done.

Please clarify.
Thanks
max

[royUK]

Try responding to helpers questions about your sheet. Also, you have not once thought to give thanks for help so far!

[maximpinto]

I do have responded for all the questions,but since i did not get the desired output was waiting for a response.
I dont feel i am wrong as each signature of mine contains a Thanks.