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?
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?
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