I have several large documents that need data filling in and I'm trying to work out the best way to do it.
I need the contents of A and B columns copying down the rows to the last blank cell then the same again for the next non blank cells.
I'm hoping someone can help - also if there's something simple that I've missed, please let me know.
Thanks in advance
I need the contents of A and B columns copying down the rows to the last blank cell then the same again for the next non blank cells.

I'm hoping someone can help - also if there's something simple that I've missed, please let me know.
Thanks in advance