| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete sheets from a workbook without creating linked formulae | Excel Discussion (Misc queries) | |||
| selecting a single sheet from a volume of sheets in a workbook | Excel Worksheet Functions | |||
| question about many sheets in one warkbook | Excel Worksheet Functions | |||
| Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
| insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
Linear Mode
