Right now I have several columns and in column "A" I want to populate
item numbers that are currently distributed throughout column "B". My
problem is that in column "B" there are several blank rows between the
items numbers. Ultimately what I want to do is if B3 to B5 are blank
I want to populate A3 through A5 with the item number in B6. B6 is
basically a Sub Total Row that has the Item #. Is there a logical
formula to accomplish this or do I need a macro?