Hi Vcoolio - thanks very much for that, I'm not too sure what you did, but it worked for me! I'm very grateful
Posts by jlw-energy
-
-
Hi - I'm trying to set up a macro that will allow me to move new data rows to another spreadsheet. I'll be pasting the latest report into a worksheet (cvent21). This is will have new registrants added at the bottom of the list. I want the latest new registrants' data to append to the bottom of another worksheet (2021). Though I only want certain columns to copy over. I've tried to teach myself how to do this, but haven't managed it, I'm not up to speed with VBA. Any help appreciated
I've attached a sample filerolling-rev-test1.xlsx