Fill in blanks with the value of the cell above

[Macro-wave]

I have a list of product codes. Some of the cells in this list are blank, and it is assumed that the blank row is the same product code as the one above it. Is there a formula I could use to have the cells fill themselves in?

Example

DO-566
DO-566
<Blank Cell>
DG-233
<Blank Cell>
<Blank Cell>
..........
I've tried the following, but it only yeilded each of the cells having the same values.

=if(isblank(A2),A1,A2)

With this, I allowed circular references, but it still yeilds that same result stated above.

[oldchippy]

Hi,

Select the column, go to Edit > Go To > Special > Blanks, type = in the formula bars, hit the up arrow then Ctrl+Enter. you should now have the cells fill with the values above

[Richard Schollar]

Select the cells in this column and hit F5 then hit the Special button on the dialog that will open then in the next dialog that that opens check Blanks and hit OK. This will select all your blanks cells. Without doing anything else, type '=' (without the quotes) and hit the up arrow of the cursor keys and enter with Ctrl+Enter. This will enter a formula in each of the blank cells that point to the cell immediately above the blank cell. You can then use Copy and PasteSpecial>Values to fix these formula values if required.

Richard

[shg]

Select all the cells containing product codes and interspersed blanks.

Do Edit > Go to > Special, Blanks

In the formula bar, type =, hit the up arrow, press and hold the Ctrl key, and hit Enter.

Copy the column and paste values over itself.

[Macro-wave]

That's cool!!!
Thanks for the help.

[tejvilsan]

Can u please provide the macro for same?

Thanks.

[Cutter]

Hello tejvilsan, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.