Repeat Cell until blank, then use the cell directly under blank and start repeating that cell.

[Johnny Thunder]

Hello,

I have a spreadsheet that has several pieces of data that is next to a column with totals Column H has one name then multiple codes under it, I only need the first name in cell H3. In Column I cell I3 is the amounts I need.

What I am trying to achieve is placing a formula in the column before H and have it say (Repeat cell H3 until Blank, skip one cell and then return the new name under blank and fill that down and so on and so fourth until data is complete.

I have attached a sample of the spreadsheet, please see Highlighted cells for Question. Thank you in advance.
file:///C:/Documents and Settings/JLee/Desktop/Repeat Cell Until New Cell Appears.xls

​

 

[SamTYler]

No

 

[Johnny Thunder]

Was that a No for a formula that you know of that can achieve the same goal? Also, the macro is populating the wrong column, I only needed column J. Your macro is accounting for Column I which I do need to make any changes to.

 

[SamTYler]

change the valye of J to = 9


Read the macro and you'll see that the comment next to J says it is the column of values.

You'll also see that JValue is Typed as currency. Compare this macro to the first one I gave you and change it's Type to suit.

I'm leaving for the day, so you will have to do just a little bit of wotk for yourself.

 

[Johnny Thunder]

Okay. Thank you again for all your help Sam.