I'm looking for help with creating a macro that will fill blank cells in column A with an Account number. In the attached sample, I would like the text in A6 to be copied from A7 to A54 (stopping at A54 because there's already text in A55), then copy the text in A55 from A56 to A98 (again stopping at A98 because there's already text in A99), then copy the text in A99 . . . and so on. The rows to copy from and to will change, so the macro needs to start with A6 but then only copy to the point where text is encountered and copy that new text forward. I can put the word END at the cell where I would want the macro to stop.
Thank you!
Bookmarks