Hello All - new user here! I was hoping to get some help to create a macro to do the following;
- I have a spreadsheet that tracks financial data through time
- 'data' tab has data in random cells i.e. A1, A2, B1 and B2
- data in 'data' tab is updated periodically, say once every few days
- after pressing a command button, data in cells A1, A2, B1 and B2 is copied and pasted onto a 'change_log' tab
- 'change_log' tab will time stamp data, and add new values under previous data
- 'change_log' tab will add data in specified cells, i.e. D2, D3, D4 and D5
- data in 'data' tab is then updated with new value
- process repeats, with historical financial data saved in the 'change_log' tab
I'm not familiar with VBA or macro code, so was hoping to get some help with examples to achieve what I'm after.
I hope this makes sense. I've attached a simple spreadsheet to try and ilustrate.
Thanks in advance for your help.
Bookmarks