Excel sheets

  • Thread starter Thread starter Cory
  • Start date Start date
C

Cory

I am trying to link worksheets in a way that allows a sheet to be auto
updated when I add a comment or format the color of a cell. Is this possible?
So far, only the text gets updated, not the insertion of a comment, nor the
format of cell color. Please help. Thanks
 
Cory,
Once you have linked the cell, select the cell, copy.
The linked cell, select cell, edit, paste special, select formats and
comments.
That should do it.
hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel VBA 1
Change cell color in protected sheet 1
How do I lock ONLY the formatting on an excel sheet? 2
Excel Macro to automatically go to the right of the last colored cell 0
Word to Excel: Export comments with text and line number 0

Back
Top