Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
Problem: I add data to an INPUT column in a spreadsheet monthly. How do I make my functions, other lists and charts, that also need to update accordingly based on the original INPUT column (some of them may be in another worksheet in the same excel file), to automatically recognize that there is a new input, and concomitantly update themselves.
To me there are 3 types of updates necessary here, one is function update in a single cell; another is list updates that move down a row, and charts that need to add points to a line etc.
Thanks,
Chong & Josh Read More