Automatically copy data from multiple sheets into one summary sheet

[sakshi_sak]

Hi,

I am new to excel and i am having a challenge now. I have a project spreadsheet which has one main summary sheet and n no.of sheets for individual projects. What i want is,

1. when a project sheet is added, when common items such as project name, domain,loc etc are populated, i want the same information to be updated in the summary sheet as 1 row for each project.

2. The summary sheet data organized columns wise, whereas the individual project sheets have data organized row wise.

3. Everything is in one workbook

I am not sure how to accomplish this, can any one help??

 

[Faseeh]

Hi sakshi_sak,


Welcome to the Chandoo's forums! While i searched out this forum itself i found following thread that might help you any:


http://chandoo.org/forums/topic/how-i-create-a-summary-worksheet-on-multiple-worksheets-which-keeps-growing


..If not consider uploading a sample workbook!


Regards,

Faseeh

 

[sakshi_sak]

Hi Faseeh,

Thank you for sharing the post i tried the macro and it didnt quite work for me, I am a newbee to macro programming and hence couldnt figure out how to alter it to suit my needs, i am uploading a sample of what iam working one please help.


P.S how do i upload a file here?

 

[sakshi_sak]

I figure how to share my workbook, here it is:


http://dl.dropbox.com/u/79735838/Sample%20to%20share.xls

 

[Faseeh]

Hi sakshi_sak,


Please see attached file:


http://dl.dropbox.com/u/60644346/Sample%20to%20share.xls


...sorry for late reply and waiting for feedback.


Regards,

Faseeh