+ Reply to Thread
Results 1 to 4 of 4

Link data between sheets

  1. 08-22-2015, 07:20 AM #1
    dtaphuong is offline
    Registered User
    Join Date
    08-21-2015
    Location
    Ho Chi Minh
    MS-Off Ver
    Vietnam
    Posts
    40

    Link data between sheets

    I have 4 sheets

    When I add the contract number in Sub1, the data will appear the other columns in Sub 1, Sub2, Sub3

    Besides, when I change the data any columns in Sub1, Sub2, Sub3, "Total" will be updated the changed data

    I think that the problems can be solved by VBA but I dont know that.

    Thanks for any help
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-22-2015, 08:44 AM #2
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Link data between sheets

    Hi there. Check this out...
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 08-22-2015, 09:17 AM #3
    dtaphuong is offline
    Registered User
    Join Date
    08-21-2015
    Location
    Ho Chi Minh
    MS-Off Ver
    Vietnam
    Posts
    40

    Re: Link data between sheets

    Quote Originally Posted by Glenn Kennedy View Post
    Hi there. Check this out...
    If u use vlookup, I cannot update the data from Sub1, Sub2, Sub3 to Total

    Thanks
    Reply With QuoteRegister To Reply
  4. 08-22-2015, 09:22 AM #4
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Link data between sheets

    Sorry - I misunderstood you. I now see that you want the information to change in BOTH directions. In that case - ignore my post. It certainly will not work!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Link data between two sheets
    By dtaphuong in forum Excel General
    Replies: 2
    Last Post: 08-22-2015, 07:22 AM
  2. Link data to an ID across multiple sheets
    By Rsnead91 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-20-2014, 11:28 PM
  3. [SOLVED] VBA to Move and Link Data to other sheets
    By mhernandez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 04:41 PM
  4. [SOLVED] link data between sheets / workbooks
    By nighttrainrex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2012, 01:02 AM
  5. Data from different sheets (If it is addressed before need direction to the link)
    By kevinfa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-06-2012, 03:26 PM
  6. [SOLVED] Using = sign will link data between sheets but not colour. Why?
    By Laurie21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Using = sign will link data between sheets but not colour. Why?
    By Laurie21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1