Solved: need to copy data from one workbook to another on selected cells

[zebradoby]

Here is the source file, template and macro. Thanks for your help. Rory i owe you big time.

[zebradoby]

Hi Rory

i took the p/w out and still get run time error 1004. Can anyone please help.????

[zebradoby]

Hi Rory

I separated all the cells. The attachment has macro, template and source file. I still get Run time error 1004. Can u help?

[rory]

The code worked fine once I removed the last merged cells. Attached is a revised version with a tweak and some tidying up.

[zebradoby]

Hi Rory

Thanks for your help. Do you remember by any chance what cells did you remove from template xls file ?

" I removed the last merged cells"

I have a template with all the headings and formulas that i will need to fix so wanted to know. I will continue to locate those cells meanwhile myself.

Thanks

[rory]

I just selected all cells, then unmerged them!

[zebradoby]

ok thanks for your help. You are the best. Thanks once again.

[rory]

Glad to help. You may want to close this question and open a new one if you have more issues, as this is getting a bit long!