Forum Discussion
Reference Cell with notes
Is there a way to reference all data (including notes and/or comments) from a cell on one sheet to a cell on another sheet. For example, on Sheet1, Cell A1 includes data and a note. If I use someth...
I agree with you. But, I have had the misfortune of having to work with people who are resistant to even a minor change in how they input data in excel. So, I've had to try and learn how to help them in spite of their best efforts to not be helped.
I assume this is a similar problem. The method you propose is BY FAR the better option.
I assume this is a similar problem. The method you propose is BY FAR the better option.
Yes. I will do both, but whenever possible, I do my best (and often successfully--especially if the existing practice is still in the early stages) to point to more effective use of Excel's marvelous abilities to manipulate, extract, summarize...
What I find, as a general observation, is that people who are relatively new to Excel will often essentially transfer over what I'll call a paper-ledger-spreadsheet mentality. That's what often leads to monthly sheets, or business inventory tracking with separate sheets for different categories of products, etc. In all such cases, that "separate sheet" could readily be handled simply by a distinct column--or by dates alone, in the case of the monthly sheet mentality (Pivot Tables, as you no doubt know, will take a set of dates and consolidate them into monthly summaries).
What I find, as a general observation, is that people who are relatively new to Excel will often essentially transfer over what I'll call a paper-ledger-spreadsheet mentality. That's what often leads to monthly sheets, or business inventory tracking with separate sheets for different categories of products, etc. In all such cases, that "separate sheet" could readily be handled simply by a distinct column--or by dates alone, in the case of the monthly sheet mentality (Pivot Tables, as you no doubt know, will take a set of dates and consolidate them into monthly summaries).