| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy data from WS to WS in same workbook
I'm not sure how to accomplish this and I've searched previous postings with
no luck. My WB titled "Today" has numberous WS. WS1, WS2, WS3, WS4 and so on. I'd like to copy the info in col A and B of each worksheet, only if the rows are populated and copy the data to Sheet titled "Final" into Col A and B. Then in Col C of the Final sheet, I'd also like to capture the sheet titled where the data was copied from....WS1, WS2 etc. My plan is to launch a macro with a button command so once the user enters all the data into the various WS, they would just click the command button to run the macro to bring in the data. Any help you can give me is appreciated, thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1.Open workbook. 2 copy data. 3 replace data. 4 save workbook. | Excel Programming | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| Import/Copy some data from one workbook to a similar workbook | Excel Programming | |||
| Selecting data from 1 workbook to copy and paste to a 2nd workbook | Excel Programming | |||
Threaded Mode
