Copy values in to next blank row with a loop

**adam2308** · 09-11-2011, 06:48 PM

I want to add some vba code to the button on the attcahed example.

All notes on what I want it to achieve are on the 'coupon' worksheet.

If anything is unclear please let me know.

Thanks,
Adam.

**Marcol** · 09-11-2011, 07:52 PM

If anything is unclear please let me know.

All of it ...

What are you trying to achieve?

**adam2308** · 09-12-2011, 06:09 AM

Firstly, I should perhaps point out that this is purely an example.

The values in I and J will not all be the same in reality and the data in 'Selections!A2:X600' will not just be 'x'. Formulas in Column P will change based on the different values entered in to Y2 and Y4.

The macro will create a worksheet ready to be saved as csv file for uploading in to an IT system.

**Marcol** · 09-12-2011, 07:22 AM

Try this in a standard module, run as a macro, or connect to a button if you must.

Please Login or Register  to view this content.

Is that what you mean?

**adam2308** · 09-12-2011, 09:59 AM

Thanks Marcol. This is on the right lines but needs what I would think is a slight amendment.

The values from columns I and J want to be inserted in to cells Y2 and Y4 of the 'Selections' worksheet not 'Temp Selections' then all values copied over to the next blank row in 'Temp Selections' (values and number formats).

As you can see from this slightly amended example the values in column P change dependent on the values in Y2 and Y4 so this is why the values from columns I and J need to be inserted to 'Selections' first and then the values of A2:X600 pasted in to the 'Temp Selections sheet. Then repeating the process for the next row on the coupon until we reach the bottom of the list.