- Joined
- Aug 3, 2010
- Messages
- 1
- Reaction score
- 0
I've been trying to find some code but come up with nothing.
I have a spreadsheet tracking a share portfolio with a time ( =NOW() ) and portfolio total in J1 and J2.
The prices update automatically every 5 minutes with a data refresh from the web.
How do I copy J1 and J2 into worksheet3 into the next empty cells in column B and C every time that J1 is updated with the new 'now' time?
Thanks in advance
Tony
I have a spreadsheet tracking a share portfolio with a time ( =NOW() ) and portfolio total in J1 and J2.
The prices update automatically every 5 minutes with a data refresh from the web.
How do I copy J1 and J2 into worksheet3 into the next empty cells in column B and C every time that J1 is updated with the new 'now' time?
Thanks in advance
Tony