Add data from specific cells to growing list

[dan0188]

Hi All,
I am stuck on how to proceed with a problem. I need to send data from a specific cell and send it to another worksheet as a growing list.
For example, I have a date in "Sheet 1, F1" and the Total Cost in "Sheet 1, J1". I want to send the date and cost to "Sheet 2"

Say in Sheet 1, "F1=31/03/2017" and "J1=$200"

I want to select a custom button saying something like "Export"

Then 31/03/2017 shows in "Sheet 2, A2" and $200 shows in "Sheet 2, B2"

Now I save the changes as a new spreadsheet.

Next month, Sheet 1 now shows "F1=30/04/2017" and "J1=$173"

I select the "export" button

Now Sheet 2 shows "A2=31/03/2017", "B2=$200", (both from data from last save)
"A3=30/04/2017", and "B3=$173" (New data entered)

Then the following month, new data goes to A4 & B4, then A5 & B5, etc. every time I select "export".


I've posted under VBA/Macros thread as I am guessing that something like this would need a macro. I've been mining excel tips/tutorials/forums and cannot find anything yet.

Thanks in advance!!

[Marc L]

Sub Demo() 
    Sheet2.Cells(Rows.Count, 1).End(xlUp)(2).Resize(, 2).Value = Array([Sheet1!F1].Value, [Sheet1!J1].Value) 
End Sub  

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[BadlySpelledBuoy]

Perhaps the below code in a standard module and attached to a command button will do?

Please Login or Register  to view this content.

See attached.

BSB

[dan0188]

YES!!
This is exactly what I needed! Thank you so much!!