Copy and Paste special

[F. Lawrence Kulchar]

I have 17 worksheets, EACH 34 x 102 columns wida!, i.e., 3,468 total cells:

I wish to "merge" all the data into one sheet!

Each sheet has 204 distincts cells filled up'''in othe words, no cells
occupied in sheet 1 are used in sheet 2, nor in sheet 3, etc....all the way
to week 17.

(17 times 204) equals 3468; I wish to copy all the filled cells on each of
the 17 sheets onto one sheet, thus filling ALL the cells?

How can this be accomplished?

Thanks,

FLKulchar

 

[Peo Sjoblom]

http://msdn.microsoft.com/en-us/library/cc793964.aspx

--


Regards,


Peo Sjoblom

 

[Herbert Seidenberg]

Use PivotTable.
No code, no formulas:
http://www.savefile.com/files/1804749