creation of a macro in a master data collection workbook.

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I am trying to create a macro which will copy data from
the sheet it is embedded in to a master data sheet
whatever the data sheet has been named. i.e. can i embed
a macro which will change it's host name to whatever the
workbook is named.
 
The Host Workbook is the object named «ThisWorkbook».
The hilighted (active) workbook is the object
named «ActiveWorkbook».
Of course, Thisworkbook and Activeworkbook could be the
same.
E.g.
ThisWorkbook.sheets(1).range("A1:D10").copy destination:=
ActiveWorkbook.sheets(2).Range("A20")
 
You must log in or register to reply here.

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

Run macro from active workbook whose name keeps changing 20
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to Compile Data from Different Sheets 2
Pasting cell contents into a macro 1
Macro for all Excel Workbooks to print to PDF 2
Macro to copy specific data from master workbook to another workbook 13
Save record Into master sheet! 1
Macros to extract data frommultiple workbooks to a master workbook 0

Back
Top