MACRO to Merge Sheets

[idontexcelinexcel]

Hello, I'm very to new macros and am trying to find tweak the one below. It's not quite working properly.
I want to merge the data from the first three worksheets of the attached file to the last worksheet called "Merged Data". Appreciate the help.

Thanks!

Please Login or Register  to view this content.

[alansidman]

Seems to work for me. What is your issue? What is not correct about the way it processes.

[idontexcelinexcel]

Hi Alan, it's not copying the data from the blue worksheet (2nd one).

[scottiex]

It assumes you are entering data in column A
if you arent maybe

Please Login or Register  to view this content.

should look at J or another column eg

Please Login or Register  to view this content.

Edit : added the "lr4 ="

[idontexcelinexcel]

I still can't get this to work.
Can you tell me which part of the code to edit?

Thanks....sorry but I'm not good at macros at all.

[scottiex]

I think there was another error in your macro - you were using the last row of sheet 1 on sheets 2 and 3
anyway - On the assumption that column J ALWAYS has data see the below

Please Login or Register  to view this content.

[humdingaling]

if your information isnt a square data block. ie all cells are fill in for every row so you have left with sometimes blank cells on last row (like in your example)
try another method to find last row

Please Login or Register  to view this content.