Copy and Paste special
 

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

Copy and Paste special
 

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

--


Regards,


Peo Sjoblom

"F. Lawrence Kulchar" wrote in
message ...
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

Copy and Paste special
 

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