Why not enter the data directly into the worksheet? I'm not sure why you
would need forms for this.

However, here's some pseudocode (untested):

Dim rng As Range
Set rng = Cells(Rows.Count, 6).End(xlUp).Offset(1)
rng = somevalue
rng.Offset(, 3) = someothervalue

Etc.
__________________________________________________ ______________________



"Paul Black" wrote in message
oups.com...
Hi everyone,

I have a sheet named "Input". Data goes from A1 to about GH????. I
would like to add data to it three times a week. Firstly I would like
to find the first blank cell in Column F and be able to enter a value
into it ( e.g. F2569 ). I would then like to enter data in cells
I2569, J2569, M2569, R2569 and several other cells on row 2569. The
columns for data to be entered will not change only the row number
three times a week. Then the next time the data would go into cells
F2570 etc. I don't know anything about Forms or such like but I would
assume that this would be the way to go. Can someone please point me
in the right direction.

Many thanks in advance.
All the Best.
Paul