| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining tables from several spreadsheets
Hi.
I use Excel 2000 and have several sheets that I need to combine. On every sheet there is a table, starting in A1, that will look something like this: (sheet1) Ugs Uos Uws A1 - B1 - C1 A2 - B2 - C2 (sheet2) Ugs Uos Uws A3 - B3 - C4 A4 - B3 - C4 There are about 40 of these tables on different sheets and I would like to combine these on one sheet like this: Ugs Uos Uws A1 - B1 - C1 A2 - B2 - C2 A3 - B3 - C4 A4 - B3 - C4 How can I do this using VBA? The tables is of course much larger then what I have shown you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filters don't work after combining several spreadsheets into one | New Users to Excel | |||
| Combining spreadsheets | Excel Worksheet Functions | |||
| Combining two spreadsheets. | Excel Discussion (Misc queries) | |||
| Combining spreadsheets to a master sheet | Excel Discussion (Misc queries) | |||
| Combining information from 2 Spreadsheets into 1 | Excel Discussion (Misc queries) | |||
Threaded Mode
