Dec 03 2022 01:16 PM
Hello guys,
need your help with this one.
I've searched all over the internet for a solution but couldn't find any. I know that they have changed the old "comments" to NOTES and added the new COMMENTS like messages. I need the COMMENTS as messages right now.
Attached you will find the excel file to make it easier for you. Here is what I got:
- one excel file with two sheets
- first sheet: "orignal "(here is where I assign each person name to the corresponding day and a comment). It can be one single comment or multiple comments in same cell ---> as seen in cell C3.
- second sheet: "COPY" (retrieves only comments from sheet "original")
End result:
- just like in the screenshot from bellow, comments need to be "replicated" in sheet: COPY in comment format (not as cell values)
- if is impossible to do it with COMMENTS we can do it with traditional NOTES instead
any advice is welcome
many thanks in advance!
Alecs
Dec 04 2022 02:05 AM - edited Dec 04 2022 04:07 AM
Hi again,
any ideea about this topic would help a lot. Also, if it would be impossible to replicate the comments then we can just extract them as cell values. Thanks