| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypassing Worksheets when scanning worksheets for data
Hi have a workbook with 5 worksheets. The first one is 'Main', the Second is
'Report' and the 3-5 are 'ABC', '123', 'POG'. I want to write VBA code that looks at all spreadsheets in the workbook except 'Main' and 'Report' and then copy data from cell A2 and B5:B10 from each of these worksheets (data is in the same location for each worksheet) into the 'Report' worksheet's cell A1 through to G1 (for the sheet 'ABC'), A2 through to G2 (for the sheet '123'), A3 through to G3 (for the sheet 'POG'), etc... How can I do this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to consolidate all worksheets data into 1 worksheets? | Excel Discussion (Misc queries) | |||
| How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
| How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
| Need code to protect worksheets - amount of worksheets varies | Excel Programming | |||
Threaded Mode
