Copy Comments throughout Workbook - Is it possible?

[AgapeDisciple]

I have a workbook that has 12 spreadsheets (1 for each month). If the
user changes a heading title in January's "Category" row, all of the
months update to use the new heading title. I'm doing this by using a
simple formula in the other month's sheets:

=JAN!B2

My question is if the user adds a comment to cell B2 in the JAN sheet.
How do I copy that throughout the spreadsheet as well?

Thanks,
Logan

 

[aaron.kempf]

a) use a database
b) learn 3rd normal form

or

play with your spreadsheets all day long and keep your comments in 100
different places for all I care

-Aaron
DBA / Developer

 

[Pete_UK]

Well, if you don't care then keep your comments to yourself.

Pete

 

[aaron.kempf]

Just because you're country hasn't been relevent in world affairs for
close to a century; does that mean you should have 'short-mans complex'

maybe on 'that side of the pond' they dont grow them smart enough to
use databases?

oh wait a second; there aren't any software companies in Europe; so
it's just a bunch of stupid kids running around with Excel Macros?

ROFL

-Aaron

 

[David McRitchie]

Hi Logan,
The lack of an answer for two weeks is probably just as informative
as my answer. You really can't do that, just like you can't copy the
format from another cell. What you can do is set up a hyperlink
to the cell so you get the cell value and link of the other cell.

Pages on Cell Comments that might be of interest
http://www.mvps.org/dmcritchie/excel/ccomment.htm
http://www.contextures.com/xlcomments03.html#AllSheets