Hello all,

I apologize in advance for what seems to be a common theme in questions, but although I've found similar questions the details seem to always be different enough that I'm unsure how to adapt the code to suit my needs.

I have an Excel workbook that is created a few times a month from a template. When I update it I run a macro that saves a values only copy with the current date. I'd like to copy non-blank rows (from row 8 down) into the first empty row in a master workbook that is saved on a network drive. The path to the master workbook is "B:\8MP\BG\Trade Pre-Advice\BG Trade Confirm Master.xls"

I'd appreciate if someone can get me started in the right direction.

Thanks,
Dylan