Hello, and thanks for having a look at this post. I am trying to create a macro that will auto-populate empty cells with the number of the previous cell until the next unique number. Example below... Thanks in advance!
Screen Shot 2015-06-29 at 1.01.48 PM.png
Hello kcarth,
Does this need to be VBA? Using your shown example, in cell B2 and copied down you could use this formula:
Please Login or Register to view this content.
If you need the results to be in the same column as the original data, you could then copy the formula cells, Right-click cell A2 -> PasteSpecial -> Values. Then delete the formula cells/column.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
VBA solution, might need to adjust the range:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks