I have a large spreadsheet with 19 columns and a couple of hundred rows. I’m looking for a macro that will move an entire row of data to another workbook only if there is data filled in on a certain column. So if data is entered into cell P2, that row of data would be moved from WorkbookA to WorkbookB. There IS a header on the master spreadsheet.
I’m sure this is a simple fix, but I am at a loss.
Any help would be appreciated!
~Dre