Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

0

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!

SVDEXCEL

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
Discuss



Answer the Question

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