Auto Update Comments

[cmonthetic]

Hi,

I have been handed an Excel 2003 spreadsheet which contains several worksheets with one worksheet used to display data simply as a Yes/No entry.

The users of this spreasheet would like to see the additonal information for each piece of linked data displayed using the 'Comments' function if possible.

Basically is it possible to link an entry from one worksheet and display it as a comment in another worksheet?

TIA

 

[xlbo]

not without VBA

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[fumei]

And in which case, if you want to continue on with this, post in the VBA forum.

Ta-da! Inside joke.

Gerry
My paintings and sculpture

 

[xlbo]

lol

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question