Insert data every other row?

[MusicJunky]

Here is a shot of what my workbook looks like currently

Insert Data every other row or as needed.png

Every RED "X" you see in Column A indicates the areas needing data copied

I need everything except the condition to be copied from the above rows. All the way down

When it is copied I need the Condition of the new data to say "REFURB" instead of "NEW"
Due to a formula in F2 that copies the UPC from B2.

I can do this manually but it takes way too long

any help is greatly appreciated and endorsed

[teylyn]

Hello,

- select columns B to F
- hit F5 to open the Go To dialog (or use Ctrl-G)
- click "Special"
- Tick "Blanks" and hit OK
- with the current selection, start typing a = sign, then hit the up arrow on the keyboard. That will enter a formula like =B4
- hold down the Ctrl button and hit Enter.

Now all the previously blank cells contain the text above it.

In cell E3, type the formula

=if(B3=B2,"Refurb","new")

Copy that formula down to the last row of data.

Finally, select all the data, copy it, then use Paste Special > Values to overwrite the formulas with the values.

cheers, teylyn

[MusicJunky]

You have helped a tremendous amount thank you so much!