Formula to Populate Cells

  • Thread starter Thread starter nejohnso76
  • Start date Start date
N

nejohnso76

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?
 
Copy column B into column A, then if A3 is the first cell that you
want this to apply to, highlight A3 down to the last cell in A that
contains an Item number. Then press F5 (GoTo), click on Special and
then click Blanks. Then begin to type in a formula - type = and click
cell A4 and then press CTRL-Enter.

All the cells in column A will now contain the appropriate Item
number. You can use paste special to fix the values and get rid of the
formula.

Hope this helps.

Pete
 
Back
Top