Can Cell content will displayed in comment box

Discuss the spreadsheet application
Post Reply
User avatar
chandrankrishnan
Posts: 63
Joined: Sat Mar 05, 2016 1:21 pm

Can Cell content will displayed in comment box

Post by chandrankrishnan »

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
Attachments
Date Vs Activity.ods
(14.48 KiB) Downloaded 96 times
OpenOffice 4.1.2 windows vista
User avatar
Zizi64
Volunteer
Posts: 11345
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Can Cell content will displayed in comment box

Post by Zizi64 »

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.
User avatar
chandrankrishnan
Posts: 63
Joined: Sat Mar 05, 2016 1:21 pm

Re: Can Cell content will displayed in comment box

Post by chandrankrishnan »

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
Attachments
Date Vs Activity1.ods
(40.15 KiB) Downloaded 85 times
OpenOffice 4.1.2 windows vista
Post Reply