Hi,
I have a worksheet that acts as a user form and would like to have a submit button that transfers the data to another existing worksheet. The data though will not run in sequential order on the second sheet, eg wont go A1 then A2 etc it will need to go A1 then A15 then A2 and so on.

example
Form 1 (user form)
A1= car type
A2= colour
A3= model

Form 2 (want to copy to via submit button form 1)
A1 = model
A2= car type
A3= colour

Any help will be greatly appreciated