Forum Discussion
Extracting content from all cell notes on Excel sheet
I have used an Excel Sheet to record blood pressure readings for my health, and I have put a daily journal remark in a separate cell note for each day. I have hundreds of these notes, and I am trying...
Hi Chris, this function worked fine for me but when note changes my formula does not refreshes, do you know why?
Thanks in advance
Thanks in advance
EloyMendoza- it looks like https://professor-excel.com/excel-extract-comments-text-to-cell/ was updated for threaded comments. I have this version of Excel now so I can't test on an older version. My guess however is that you'll need to refresh the formula manually (enter edit mode and then enter; or similar manually) or I suppose you could do some VBA on cell change to refresh the calculation.
- Chris, Thanks for your quick answer.