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 |
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) |