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.
![mrexcel.png](/board/proxy.php?image=http%3A%2F%2Fi241.photobucket.com%2Falbums%2Fff306%2Feean01%2Fmrexcel.png&hash=2bb5284c94d72b99f3c09cd6baa1bb91)
I'm hoping someone can help - also if there's something simple that I've missed, please let me know.
Thanks in advance