asked on

copy data from single cell into merged different wkbs - part 2

Hi Experts

here is the link to the original question:-https://www.experts-exchange.com/questions/28145987/copy-data-from-single-cell-into-merged-different-wkbs.html

The new question is if I want to repeat the process for columns b, c, d, e, and f....from wkb1 to wkb2....as per my first question...

SOLUTION

Saqib Husain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

route217

ASKER

Hi ssaqibh

firstly thanks fir the feedback. But I am getting a run time error 13...type miss match on line
do until rngSrc.value =""

route217

ASKER

Using excel 2003....

Saqib Husain

Change it to

do until rngSrc.cells(1,1).value =""

route217

ASKER

Ok ssaqibh

slight problem now the macro is copying the sixth cell value in wbk1 and pasting that into wkb2...as the merged cells in wkb2 are in rows of 6....

When the macro should be copying each cell value in rows a2:f until last ccell with value. ...into the merged cells corresponding range wkb2.

route217

ASKER

Any ideas ssaqibh,??? And apologies if u are logged off taking 5 minutes.