View Single Post
  #1   Report Post  
Andy Tallent
 
Posts: n/a
Default UserForm Data to Spreadsheet

Is it possible when writing Userform data elements to a spreadsheet to
specify exactly the cell you want the first piece of data to populate. I
have tried a number of methods which allocate the data to the first available
free cell or row but this is not exactly what I want to do here.

For example, I would like to specify Cell "C4" to receive the first piece of
data from the userform with subsequent pieces of data from that submission
populating "D4,E4,F4" etc. The next time data is submitted from the Userform
I would like it to start at "C5". Sorry for this lengthy explanation but any
help would be very much appreciated.

Kindest regards as always.
--
Andy Tallent