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

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

Hi Rory

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

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?

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

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

I just selected all cells, then unmerged them!

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

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!