How to create a form that logs data?

[Aesir]

I would like to make a form where a user can fill in information in an easy to ready format, then click a submit button, and have the data moved to another sheet or file from where the data can be merged into another document. Each time the user fills out the information and clicks submit, a new line of the data is created in the destination. Here's a picture to show what I'd like to do:

\1

Any help would be great. Thanks!

[rylo]

Hi

Try this.

Sub bbb()
  Dim OutSH As Worksheet
  Set OutSH = Sheets("Sheet2")
  
  outrow = OutSH.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
  
  OutSH.Cells(outrow, 1).Value = OutSH.Cells(outrow - 1, 1).Value + 1
  OutSH.Cells(outrow, 2).Value = Range("C3").Value
  OutSH.Cells(outrow, 3).Value = Range("C4").Value
  OutSH.Cells(outrow, 4).Value = Range("C5").Value
End Sub

rylo

[Aesir]

Thank you for that. I may be in over my head here, but where would I apply that code? To the button? Would that constitute the macro?

I created the simplified picture to visually explain what I'm trying to do, but perhaps it would be helpful if I just attached the file that I'm actually working on. I put a button in there, but wasn't really sure what to do with it.

[rylo]

Hi

Don't have excel 2007 on this machine so can you please save the file in 2003 format.

rylo

[Aesir]

Here's the same file in 2003 format.

[rylo]

Hi

When in excel, hold down the alt key, and press F11. This will open the VBE. Now go Insert, Module and paste the code into the module. Now go back to the spreadsheet, hold down the ctrl key, right click on the button, select assign macro, select the macro bbb. It will now run when you press the button.

However, the macro was built for your post example, and won't do anything much for your working example. Can you advise where the data on Form is meant to be posted on Database? That way we can set up the code to transfer the data to the right cells.

ryl