View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Olmsted57 Olmsted57 is offline
external usenet poster
 
Posts: 4
Default Combining data from multiple worksheets.

I have 3 worksheets (W1, W2, W3). W1 has data in cells A1 through A10 (in a
worksheet that has 25 rows). W2 has data in cells A1 through A5 (in a
worksheet that has 25 rows). I would like W3 to list W1 A1:A10, then W2
A1:A5 in its A column, but ignoring any blank rows. HELP!!!! I know there
must be an easy way to do this!