 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006Copy Comments throughout Workbook - Is it possible?
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 > 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 [quoted text clipped - 8 lines] > Thanks, > Logan Well, if you don't care then keep your comments to yourself. Pete > a) use a database > b) learn 3rd normal form [quoted text clipped - 19 lines] > > 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 > Well, if you don't care then keep your comments to yourself. > [quoted text clipped - 23 lines] > > > 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 > 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 [quoted text clipped - 8 lines] > Thanks, > Logan
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.