| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from one source to multiple spreadsheets
On a master spreadsheet I have on each row data for multiple spreadsheets. I
would like to set up a macro to copy this data into each of the designated destination spreadsheets. The macro I have is: Windows(SourceName).Activate Range(row, 2).Select Selection.Copy Windows(dept & ".xls").Activate Range("C3").Select ActiveSheet.Paste The problem is that "Range(row,2).Select" is not working. Is there a code which would work. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy the same 2 columns from multiple spreadsheets into one new sh | Excel Discussion (Misc queries) | |||
| programatically change source of multiple links for multiple files | Excel Programming | |||
| Linked Spreadsheets - Preventing Access to Source Sheet | Excel Discussion (Misc queries) | |||
| How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions | |||
| Copy Multiple Spreadsheets into One Workbook | Excel Programming | |||
Threaded Mode
