LinkBack URL
About LinkBacks
Hi,
I need some help with cell comments:
1. I'm able to create macro which adds comments of another cell, however once I hide whole reference column=> comments are disappeared . How can i overcome this issue. thanks in advance!!!
show comment of the hidden columns
Hi,
I need some help with cell comments:
1. I'm able to create macro which adds comments of another cell, however once I hide whole reference column=> comments are disappeared . How can i overcome this issue. thanks in advance!!!
Where would you like to show the comments, if the cells are hidden?!
Only suggestion would be to write the comments to a visible range...
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks Olly for the prompt response . Actually I need to perform the following:
1. I have "actual" dates vs "planned"
2. "Planned "dates I would like to hide and show this information in "actual" dates columns as a comment;
3. Comment should appear automatically upon entering "actual" date
4. Planned dates are in K,M,O,Q,S columns;
5.Actual dates are in L,N,P,R,T columns;
6. Number of rows always changing
Thanks in advance
anyone to help?
Try something like:
Please Login or Register to view this content.
Create thank! Working!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks