Hi,
I had some workouts in my spread sheet.Attached my work sheet for your reference
I have my activity sheet which number of persons x1,x2,x3.....
The activity of all x1,x2,x3... has to be mapped with date (in comment box ) of 1st may,2nd may .....so on.
By help of this forum i read an topic with insertion of comment with some text,where i am struggling to get the cell reference in comment box it allows only the text...
Any help by formula or macro program to get the comment with activity as shown in cell D3.
Thanks in advance
Can Cell content will displayed in comment box
- chandrankrishnan
- Posts: 63
- Joined: Sat Mar 05, 2016 1:21 pm
Can Cell content will displayed in comment box
- Attachments
-
- Date Vs Activity.ods
- (14.48 KiB) Downloaded 96 times
OpenOffice 4.1.2 windows vista
Re: Can Cell content will displayed in comment box
Use a helper cell range to store DATA instead of the comment box.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
- chandrankrishnan
- Posts: 63
- Joined: Sat Mar 05, 2016 1:21 pm
Re: Can Cell content will displayed in comment box
Hi all,
Attached my sample sheet.
with help of this forum i had tried with some macro and formula to show the cell content in comment box.
Now i stucked up in macro(comment shows with cell address) which allows only one cell reference to show in comment box,whether it can be made to show with some more cell reference like E3:G3 & B4:G4 & B5:G5 & B6:G6 & B7:F7.
Also it does not allows me to call the cell reference form result sheet,so i need to call the result sheet into date sheet of reference as shown K2:Q2) to map with date.
Help me with macro or any ideas to complete the task.
Thanks in advance
Attached my sample sheet.
with help of this forum i had tried with some macro and formula to show the cell content in comment box.
Now i stucked up in macro(comment shows with cell address) which allows only one cell reference to show in comment box,whether it can be made to show with some more cell reference like E3:G3 & B4:G4 & B5:G5 & B6:G6 & B7:F7.
Also it does not allows me to call the cell reference form result sheet,so i need to call the result sheet into date sheet of reference as shown K2:Q2) to map with date.
Help me with macro or any ideas to complete the task.
Thanks in advance
- Attachments
-
- Date Vs Activity1.ods
- (40.15 KiB) Downloaded 85 times
OpenOffice 4.1.2 windows vista