+ Reply to Thread
Results 1 to 2 of 2

Interlinking and updating values in two different sheets

  1. #1
    Registered User
    Join Date
    06-19-2016
    Location
    Manipal
    MS-Off Ver
    2013
    Posts
    22

    Lightbulb Interlinking and updating values in two different sheets

    Good Morning peeps!!
    Here is a new challenge.

    Today morning I was working on Test sheet. Challenge is like this.
    "Order-Customer data" and "Buying In Sheet" sheet have status column. Now status column would have same options (From DROP DOWN) in both sheets. I want to interlink the both in such a way that If I change the status from any sheet the changed status will reflect on the other sheet in status column.

    PFA file TEST file.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,147

    Re: Interlinking and updating values in two different sheets

    You will need VBA do do this.

    And think carefully about the logic of what you wish to do .....
    Last edited by JohnTopley; 04-14-2017 at 03:24 AM.

+ 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. [SOLVED] interlinking workbooks
    By 86gts in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2012, 05:33 PM
  2. [SOLVED] Updating Values from two sheets, no particular order..
    By wholemilk in forum Excel General
    Replies: 3
    Last Post: 07-24-2012, 06:39 PM
  3. Replies: 1
    Last Post: 05-11-2012, 07:04 AM
  4. Interlinking(?) values in cells and sheets
    By ForkedStick in forum Excel General
    Replies: 1
    Last Post: 03-30-2011, 11:39 PM
  5. Interlinking Worksheets Via Macro's
    By RPickering2 in forum Excel General
    Replies: 7
    Last Post: 01-19-2011, 06:16 PM
  6. Interlinking WorkSheets.
    By RPickering2 in forum Excel General
    Replies: 1
    Last Post: 01-17-2011, 03:23 PM
  7. Interlinking Documents
    By Piper in forum Excel General
    Replies: 0
    Last Post: 07-25-2006, 12:15 PM
  8. [SOLVED] save doc. From workbook so that interlinking formulas don't follow
    By Kat Gebhart in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-29-2006, 02:35 PM

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