Data Capture - split into multiple lines

[BILLYBOB1972]

Hi All

Can anyone point me in the right direction with this one?

I am capturing time data in a vba form. The data is being entered as number of hours and to make it easier the number of days is also captured. I am then using add to functionality to post into an upload sheet for a secondary system. Unfortunately the secondary system cannot deal with 2 number inputs so I need to be able to split the output over multiple lines

e.g

Ref. Hours. Days
123456. 5 4

This needs to slit into 4 lines e.g

Ref. Hours
123456. 5
123456. 5
123456. 5
123456. 5

Is this possible? Thanks in advance.

 

[jmacleary]

Hi there. In your 'add to' section, you would need to create a loop to write the same data 4 times. Assuming your data is in A1 to C2 it would look something like:

daycount=range("C2").value
For daynum=1 to daycount
' here you have your add to code just adding columns A and B
Next daynum