| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy from one source to multiple spreadsheets
It not need to select the objects of Excel to manage them.
You can say something like below having the master worksheet activated: Range(Row, 2).Copy _ Destination:=Workbooks("DestWorkbook").Worksheets( "DestWSheet").Range("D3") Ο χρήστης "msdrolf" *γγραψε: 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 |
| Reply |
| 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 | |||
Linear Mode
