Hello,

I'm new to VBA so I need some help with the following. I have a working workbook and I want to dump all of the data into a master workbook in the next blank row. The working file will have a different number of rows of data, so I need the range to select the data in the working file based on what is in there (the range will start at B4). I think I need xldown and right?!

I've searched for an answer before posting but none of the other threads quite match what I need.

Thanks,

James