| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from various sheets and create a master list.
Looking to perfect a macro....
I have 6 sheets, each named Monday - Saturday. Each one has a specific web query on them begining in cell a1 (specifically a1 to G). I need my macro to copy the data from each sheet and paste it on the "Sorter Sheet" creating one list for the week. In plain words.... (1) Update all web queries in book. (2) Copy all data from Monday and paste starting with A1 on 'sorter sheet'. (3) Copy all data from Tuesday and paste on next available row on 'sorter sheet'. (4)Copy all data from Wednesday and paste on next available row on 'sorter sheet'. (5) ...and so on until Saturday sheet. Any help will be greatly appreciated. Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create A Master List From Several Lists | Excel Worksheet Functions | |||
| Create a copy with all data linked to the master | Excel Discussion (Misc queries) | |||
| create a master list from other sheets | Excel Worksheet Functions | |||
| I have a master spreadsheet, how do I create a copy? | Excel Worksheet Functions | |||
| How do I create a set of sheets that will update from a master? | Excel Discussion (Misc queries) | |||
Threaded Mode
