Log In
Register
Home
Active Member
October 8, 2020
Offline
How would I copy a cell (C50 sheet1) to a new worksheet(B2 sheet 2) when the value changes in C50 the new value copied in under B2 and continue to make copies underneath without overwriting itself?
example: I put my net income of trades in sheet1 Amitrade cell B25, and Vanguard sheet2 cell B25 which updates automatically when the daily stock values change. Now I need to track these changes in a progressive chart in sheet 3 and/or the dashboard. Sheet 3 records the data for Amitrade Column B and Vanguard column C and dates column A. 
Thank you very much
Walid
October 5, 2010
Offline
Hi Walid,
I wrote a post on this
and recently answered a question on the same topic
How to plot live data in Excel
The 4th reply in that forum question contains a link to a file that contains formulae and a chart that update when new data is fed into the sheet. As you haven't supplied your workbook I can't set this up for you. Give it a go and if you get stuck, please attach your workbook in your next reply.
Regards
Phil
Active Member
October 8, 2020
Offline
Good morning Phill
Per your message, please find my attached file. I am new to this subject, and still learning, so please forgive me if it does not look professional.
I have two sheets, one for Ameritrade and one for Vanguard. I added your code two times for each sheet. I tried to track the net income (bank deposit + gain/loss) in G45 (A replacement of B2) on both sheets. G45 changes by clicking the refresh button under the data tab because the daily stocks' prices change. But I did not see the VBA code I added to both sheets displayed the two columns and replicate the records of G45 in these columns. It only works if I manually change the data in cell G45, but not when it auto updated by refresh button under data tab.
On the third sheet I added another equation similar to yours that works. I copied a while ago from online but was not a perfect solution. I also added another equation that I got online. It supposed to add dates in adjacent cells next to the new records come from G45. I did not test it but you probably have a better and faster solution to associate the new records with the date. This would help to see how all of it works together.
If you would kindly give me your solution, I would be greatly appreciative.
Thank you very much for your help.
Have a great day
Walid
1 Guest(s)
