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

Consolidating all sheets
 

Use the consolidate function under Data on the menue bar.
--

WCO


"Deepak" wrote:

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

Consolidating all sheets
 

Hi Deepak

Check out my site for examples
http://www.rondebruin.nl/copy2.htm

Use this one
http://www.rondebruin.nl/copy2.htm#rows


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Deepak" wrote in message ...
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