Hi,
Found a bunch of really similar issues, but nothing that's allowed me to do what I need to do... I have three worksheets that are being consolidated into one. They each have similar column headers (these aren't tables), but not every cell in a row is blank. As a result, I can't just paste them into the next available cell.
I'm trying to find the next blank cell in column A of the International Tracker tab, and paste columns below starting from the first blank cell, and then offsetting that cell from column A to get the position of the other columns to be pasted...
As a (very rough - I've tried a billion other things but this is probably the most simple to avoid taking up space) example:
Bookmarks