consolidation of spreadsheets

[dharsana]

hi,
I am having 13 worksheets(each with a unique name)with similar row & columns.I want to consolidate all the 13 sheets and create a summary sheet(14th sheet)by using a macro(withoutlinking these shhets)Is it possible ? If so , can anyone give me a macro for this purpose?
Thanking you in advance

dharshsna

 

[DonkeyOte]

if the rows and columns are the same in the consolidated sheet this will be easier...

I would write a loop through all the cells that need populating - adding all the respective cells in the 13 sheets and entering the result in the consolidate sheet.

If you're only pulling a select few cells from the entire sheet then again, you would want to ensure that all 13 sheets have the cell you want to consolidate in the same position.

 

[PaddyD]

...withoutlinking these shhets...

why not?