I am writing a macro that will cut and paste data from different tabs and
aggregate it onto a new sheet. I would like to know the best way to search
the new sheet to find the next blank cell via a macro after data has been
pasted so I can have the macro cut and paste the next portion of data
automatically. Hopefully this makes sense. Thanks, Eric.