+ Reply to Thread
Results 1 to 2 of 2

Keeping Format While Linking Two Cells from Different Sheets

  1. #1
    Registered User
    Join Date
    07-08-2021
    Location
    St. Catharines, Ontario
    MS-Off Ver
    MS365
    Posts
    2

    Keeping Format While Linking Two Cells from Different Sheets

    Hello, so I am looking to find a way to have two cells from separate worksheets link together such that when either one is changed, the other one updates. I figured this out with the help of this forum by using this code:
    Please Login or Register  to view this content.
    Now this works fine, however there is another layer I am trying to solve now. I am trying to use multiple fonts within a cell, specifically attempting to use a font called "isoqsymbol" for specific symbols and just use "arial" for numerical values. My problem is whenever I change a numerical value or symbol, the linked cell in the other sheet updates in just plain "arial" font, leaving the symbol font out and making the cell illegible. Is there any way to keep font formatting linked along with the value? Please let me know if this is possible - or will I have to separate cells. Thank you so much.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,530

    Re: Keeping Format While Linking Two Cells from Different Sheets

    Your code just copies the values without regard to formatting. Try a copy/paste to preserve formatting:

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combining cells, keeping date format.
    By emccalment in forum Excel General
    Replies: 2
    Last Post: 02-26-2016, 11:12 AM
  2. [SOLVED] Copy row to different sheets based on one column while keeping format
    By hey1234 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-11-2014, 11:30 AM
  3. [SOLVED] Problems with Linking Cells on a Score Keeping system
    By gmdugan in forum Excel General
    Replies: 3
    Last Post: 08-06-2013, 02:54 PM
  4. Splitting a sheet into different sheets but keeping the same format as the origional one
    By boomboomblock in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-02-2013, 07:52 AM
  5. Keeping cells format after filtering
    By ElmerS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2010, 12:25 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1