Hello,
Currently, I am trying to fill in the blank cells in column B with the code found above it. There is no predictable spacing between codes and I have tried using the same formula in VBA used for dragging contiguous data to the end of the last blank row with no success. I have attached an example sheet. You will see there are various formula codes in column B...unfortunately, I need the codes in the blank cells beneath it in order to glean the necessary data from the adjacent columns.
Thank you for any help!
Bookmarks