I have a line graph that needs to update daily and I don't want to copy and paste it manually every day. How can I select cell G158 on 'Budget Summary' worksheet each day and paste the value under the same date in 'Spending Tracker' worksheet (row 38) so the line graph will update?
Bookmarks