View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deepak Deepak is offline
external usenet poster
 
Posts: 47
Default Consolidating all sheets

I have almost 250 sheets

- in every sheet i have data in few rows
for eg.
in sheet1 the data is till row 50
in sheet2 the data is till row 20
in sheet3 the data is till row 20
in sheet4 the data is till row 80

I want to pull all data on sheet 1 after the data in last row
eg.
- Sheet1 the data is there till row 50
- It should pull data from sheet 2 and paste it in row 51
- Then, It should pull data from sheet 3 and paste it in row 81 and so on

Pls Help