| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i append 4 differnt worksheets in a new master work sheets
i have got 4 work sheets with same column name e.g.
sheet 1 o/b I/b 3 4 5 6 27/04/05 89 89 233 11779 11779 11779 28/04/05 9999 9999 23324 23324 23324 11755 sheet2 o/b I/b 3 4 5 6 27/04/05 9999 9999 11779 11766 23324 23324 28/04/05 100 89 233 11791 11791 11791 so on what i want is append all these sheet in a maste sheet with the resul like master sheet o/b I/b 3 4 5 6 27/04/05 89 89 233 11779 11779 11779 28/04/05 9999 9999 23324 23324 23324 11755 27/04/05 9999 9999 11779 11766 23324 23324 28/04/05 100 89 233 11791 11791 11791 is it possible..... one more thing all are with formulas i want values in master sheet. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Pivot chart from 3 differnt sets of data / worksheets. | Charts and Charting in Excel | |||
| Cell referencing between differnt worksheets | Excel Discussion (Misc queries) | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| How to Append the Data to the Master Table | Excel Worksheet Functions | |||
| Allocate Files to Sheets and Build a Master Sheet which Summarises All Sheets | Excel Programming | |||
Threaded Mode
