saving input and calculation to a list of previous inputs and calculations


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?



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 Sub

The 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



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: 6) 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: 1282) Jan 15, '18 at 1:51 am
Add to Discussion

Answer the Question

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