View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default 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