Copying rows from Subsidary Files To Mastersheet with Formulas

  • Thread starter Thread starter Volker Hormuth
  • Start date Start date
Volker,

Glad we finally cracked it.

Regards

Bob

Wohnungsbau GmbH said:
Hi Bob,

the code will do the job.
I save many hours !
Thanks ...

Volker


Bob Phillips said:
Volker,

Sorry, I was being particularly dense. It's the same intrinsic problem as
before (must figure out why it worked in my test though!).

Change
.Range(Cells(iRow2, 1), Cells(iRow2, 5)).Copy _
Destination:=ThisBookMaster.Cells(iRow1, 1)
to
.Range(.Cells(iRow2, 1), .Cells(iRow2, 5)).Copy _
Destination:=ThisBookMaster.Cells(iRow1, 1)

Sorry for taking so long over it.

Regards

Bob
Click to expand...
way
Click to expand...
 

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

How to create a master sheet of several (12 maybe more) worksheets 1
Pulling data from sheet to mastersheet 6
Macro to merge two sheets 2
Multiple column search and Copy 7
Excel Help to copy information from one row at a time to another sheet 1
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. 4
SUM of data from multiple sheets in the mastersheet 3
Copy all formats and objects 5

Back
Top