Input Form to Get Data and Store in Another Tab in Excel (But not in Column A)


Hello There,

Thank you very much for your answers, definitely, makes easier my life and work, I'm sorry  to bother you again, using the same example of my previous question, how can I store the info not starting in the column (A2), but also in (B2) or (C2), etc in order to for example leave blank the column (A:A) and using from column (B) or any other.

Attached the macro that I'm using and the desired output print screen.

Sub data_input()
ws_output = "Data"
next_row = Sheets(ws_output).Range("A" & Rows.Count).End(xlUp).Offset(1).Row
Sheets(ws_output).Cells(next_row, 1).Value = Range("first_name").Value
Sheets(ws_output).Cells(next_row, 2).Value = Range("last_name").Value
Sheets(ws_output).Cells(next_row, 3).Value = Range("email").Value
Sheets(ws_output).Cells(next_row, 4).Value = Range("account").Value
Range("first_name").Value = ""
Range("last_name").Value = ""
Range("email").Value = ""
Range("account").Value = ""
End Sub

Thanks in advanced for your time and help!


Post Edited
CODE Tags: You must add [CODE][/CODE] tags around your code! (click the CODE button to do this when creating a post)

Answer the Question

You must create an account to use the forum. Create an Account or Login