Data to Sequential Cells
Data to Sequential Cells
(OP)
I am writing a sheet to handle slope staking data and I need to get my information from my user form to the cell. But I need it to perform a loop function so that when I input the next stations values it will insert the data to the next set of cells. Any suggestions would be helpful.
Thanks Tim
Thanks Tim
RE: Data to Sequential Cells
Vlookups are good for picking out a single cell ref i.i a station number, and then in cells you choose on antoher sheet it will fill out data taken from across the original cell.
the only caveat is that the cells that the vlooup is performed on has to be in some type of sequential order, or you have to use the false command at the end of the formula.
RE: Data to Sequential Cells
You could also name all the possible input cells ahead of time including a row number and then coordinate that with the macro loop count.
RE: Data to Sequential Cells
RE: Data to Sequential Cells
For x = 10 to 110
If IsEmpty(Cells(x,2))then goto exit1
next x
exit1:
you can then use the VB to put the value you require into the next empty cell Cells(x,2)
RE: Data to Sequential Cells
Tim
RE: Data to Sequential Cells
Dim iRow As Long
iRow = 2 'First row for data
start loop...
Range("A" & iRow) = Text1.Text
Range("B" & iRow) = Text2.Text
Range("C" & iRow) = Text3.Text
iRow = iRow + 1
end loop...
Not sure if that's what you were after...
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.