I'm totally new to VBA, so forgive any errors. Someone very kindly submitted the following piece of code for me. Problem is I can't get it to do more than a single row. Ie. it will correctly input data from row 2 of each of my 4 worksheets but then won't merge any other rows.

I am trying to merge data from 4 worksheets. Each worksheet uses an ID column but each ID doesn't appear in each sheet. Each sheet contains different characteristic data for each item (row).

Um, if anyone can help with the code I'd be really, really grateful. :-)

Please Login or Register  to view this content.