Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to set up a macro that will:
1. Open another spreadsheet and copy a set of data... 2. then return to the original spreadsheet (where the macro is recorded) and paste the data... 3. then close the spreadsheet where the data was copied from. The issue is, the names of the original spreadsheet and the spreadsheet containing the data to be copied will always change. How do I set up the macro to recognize these changes? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |