Copy from one source to multiple spreadsheets

M

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
 
J

John_John

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" έγγÏαψε:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy from one source sheet to numerous destination sheets 1
Copy Data from Closed File to Existing File 0
Copy from File 1 to File 2 5
Run macro from active workbook whose name keeps changing 20
How to: copy value from active sheet to all other sheets with VBA (in desired cell) 3
Eliminate blanks while copy row and transpose 11
Need to make sure workbook is open before proceeding 1
File Name changes with dates and Deleting Rows of Zeros 0

Top