I have a spreadsheet that calculates the cost of making a text string into a banner. I want to be able to save the input text string and the cost calculation to a list of previous strings and calculations. Does this require a macro?
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.)
saving input and calculation to a list of previous inputs and calculations
1
Answers
0
Selected Answer
Unless you want to do it by hand, yes.
Here is a macro you can use to do it:
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
End SubThe full explanation of how to use this macro and build the spreadsheet for it is located in our tutorial here: Input Form to Get Data and Store it in Another Tab in Excel
Discussion
The solution works great, thank you. I adapted it to my situation and it works fine. Is there a way (I'm sure there is) to make the "SUBMIT" button blink when it's pushed?
baddog1016 (rep: 12) Jan 14, '18 at 6:55 pm
Blink as in disappear and reappear? To make it show something when it is clicked, though not blink, you can add a form control from the Developer tab and assign a macro to it. If you don't see the Developer tab, go to File > Options > Customize Ribbon > Check next to where it says Developer.
don (rep: 1989) Jan 15, '18 at 1:51 am