exceltimes
New Member
- Joined
- Apr 24, 2020
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
I am trying to have a Notes box instead of "Line tracker" box.
I need to have multiple lines of "Date wise Notes" of Long Communication history with every entry in "Notes Cell" but do not want displaying it all the times.
I am trying to have a Note box on top to display Notes from the "Actively Selected" Row cell , instead of using "Wrap Text" directly on column because I did not like rows displaying different sizes.
for this I was thinking 2 solutions.
1) A "Notes Box" displaying notes depending on the row selected.
or
2) or may be a VBA macro that Expand the height of Row only when "selected" and resizes it when move to a different row.
How can I show Notes of actively selected row in Note BOX ( in another cell on top) ?
Actual spreadsheet is here https://indzara.com/wp-content/uploads/2017/01/Sales-Pipeline-Tracker-v1_2.xlsx
The effect I am trying to achieve is displayed in attachment.
Thanks
I need to have multiple lines of "Date wise Notes" of Long Communication history with every entry in "Notes Cell" but do not want displaying it all the times.
I am trying to have a Note box on top to display Notes from the "Actively Selected" Row cell , instead of using "Wrap Text" directly on column because I did not like rows displaying different sizes.
for this I was thinking 2 solutions.
1) A "Notes Box" displaying notes depending on the row selected.
or
2) or may be a VBA macro that Expand the height of Row only when "selected" and resizes it when move to a different row.
How can I show Notes of actively selected row in Note BOX ( in another cell on top) ?
Actual spreadsheet is here https://indzara.com/wp-content/uploads/2017/01/Sales-Pipeline-Tracker-v1_2.xlsx
The effect I am trying to achieve is displayed in attachment.
Thanks