View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac[_6_] Mac[_6_] is offline
external usenet poster
 
Posts: 1
Default Adding all the data to one sheet

Hi all,
I have several sheets in one file. All the sheets are containing the
same columns but different data. I need to copy all the data of each
sheet to one master sheet for analysis. How to do it? I mean master
sheet can have data from 1st sheet then without leaving any blank
rows, data from the 2nd sheet to be copied then without leaving any
blank rows data from 3rd sheet to be copied and so on for around 34
sheets. I think I am clear what I need.

Thanks for any help.
Raja