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

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

AgapeDisciple wrote:
> 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

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

Pete

(E-Mail Removed) wrote:

> 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
>
> AgapeDisciple wrote:
> > 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

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



Pete_UK wrote:
> Well, if you don't care then keep your comments to yourself.
>
> Pete
>
> (E-Mail Removed) wrote:
>
> > 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
> >
> > AgapeDisciple wrote:
> > > 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

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

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"AgapeDisciple" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>