Originally Posted by
tscott
Hello,
I'm a newbie to this site and forum. I've been using what I've discovered is very little of Excel's capabilities for years, and am just starting to explore the wide range of features and need a little help.
Here’s where I need help… I have 13 columns of data; each column heading is a different month and the data is whole numbers or dollars. Several individuals are responsible for adding updates each month. Is it possible to have or how do I set up a column to the right of the data to show the most recent data which would be located to the right of the previous months data each month.
This most recent is used to automatically update charts at the top of my worksheet.
Thanks very much for any suggestions you have!
TS
Bookmarks