Hi, I'm trying to track my net worth and have a cell that automatically updates each time it changes. Now I need to be able to automatically capture this cell into a table every week to be able to make a graph that updates by itself with my networth. Thanks for any help.
Welcome to the forum.
Which ‘latest’ version are you running? Excel 2019 or 365? Please update your profile.
If the cell that updates is A1, use this in your table:
=A1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you !
I'm running the 365 version.
What I'm trying to know is if there is a way to automatically capture the value of the cell that updates every week. Let's say at the end of week 1 the value is 100$ it would automatically capture it and add it to the table and same for the end of week 2. My goal is to be able to see the evolution of my net worth week by week at the end of the year.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks