+ Reply to Thread
Results 1 to 4 of 4

VBA to link cells from One sheet to another

  1. #1
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    327

    VBA to link cells from One sheet to another

    In attachment, I have 6 Sheets. In sheet "Collate", I have linked few cells from other 5 sheets.

    For some reason as per my work flow, I need to delete the 5 sheets and create same 5 sheets again.

    But as soon as I delete these 5 sheets, the link in Sheet "Collate" Become liks this =#REF!D3. It does not shows any value.

    Eben after creating the same sheets with same names the links does get updated.

    Can any one help on this?

    Is there any code which can link the same cells again to show the value of linked cell.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,630

    Re: VBA to link cells from One sheet to another

    What cell or cells was that cell linked to?
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    327

    Re: VBA to link cells from One sheet to another

    Cell values.

    If you look at the atatched file, for e.g. in Sheet "Collate" G3the value is "11" which is linked with value in Sheet "Information1"

    After the deletion of sheet "Information1", G3 of sheet "Collate" becomes #REF!.

    After the recrewation of Sheet "Information1", G3 of sheet "Collate" should restore the same value "11". like wise in all linked cells in sheet " Collate"

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,630

    Re: VBA to link cells from One sheet to another

    Ahhh

    A simple Macro to reenter all your formulas:-

    I have added a button to your Collate Sheet.

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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