Populating the Cells below

Hi Everyone, I hope someone can help me approach this situation...

I have over 4000 rows of names and dollar amounts. I can't sort this by types of dollar amounts cause the names are only listed once... for example..

Name Food Type Price
Don Milk $1.99
Vegies $5.99
Meat $4.99
Snacks $11.99
Bob Milk $4.99
Vegies $3.99
Meat $15.99
Snacks $1.99

My question is how do I auto populate the cells below Don up until Bob and then populate the cells below Bob until the next person? Is there a formula? Macro? Something?

Hi,

One non macro way. Assuming your table above is in A1:C9, use a helper column D.

In D2 enter

Please Login or Register  to view this content.

and copy down as far as necessary.
Then copy the whole of column D and use PasteSpecial values to paste it back to column A.

HTH

insert a column before names (new column A) assuming names start in now B2
in a2 put =b2
in a3 put
=IF(ISTEXT(B3),B3,A2) and drag down
once done copy paste back special values delete col b

This isn't really a formula...but it's my favorite little trick.

Also, I'm not sure if this is what you're asking for but here it is.

Assuming Don is in A2 and everything below that is blank until Bob in A6 and you want the cells A3 through A5 to say Don, this is what I would do.

In A3 put the formula =A2

Copy cell A3.

Highlight the whole area where you are looking to populate the information.

Press F5, this brings up a Go to box and click Special.
When you're in here, choose Blanks and OK.

Now you are left with only the blank cells as being highlighted.

Paste what you have copied and now all the blank cells will equal whatever was directly above it.