+ Reply to Thread
Results 1 to 8 of 8

linking data between to sheets

  1. 05-21-2016, 07:50 AM #1
    asqtexture
    asqtexture is offline
    Registered User
    Join Date
    05-21-2016
    Location
    UYO
    MS-Off Ver
    2013
    Posts
    3

    linking data between to sheets

    Hello,
    please i need help to link up data from one spread sheet to another
    here is a clearer explanation.
    (Outgoing) sheet has a unique data (CTU#) in column C, and a departure date in column F.
    when the sent items arrives, i record details in my
    (incoming) sheet, i would like to call up data (CTU#) from (=outgoing!C:C), hence when i input the CTU #, it keep track of the departure date corresponding to that CTU#, i will input the arrival date in column D, and compute in column G, the number of days spent [arrival date (incoming sheet) - departure date (outgoing sheet)] keeping track of the CTU#.
    Please, i will be glad to get help.
    Reply With QuoteRegister To Reply
  2. 05-21-2016, 07:59 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: linking data between to sheets

    use VLookup to find the outgoing date.

    incoming date minus outgoing date is the numbers of days spent.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 05-21-2016, 09:09 AM #3
    asqtexture
    asqtexture is offline
    Registered User
    Join Date
    05-21-2016
    Location
    UYO
    MS-Off Ver
    2013
    Posts
    3

    Re: linking data between to sheets

    thank you so much, let me get at it, immediately
    Reply With QuoteRegister To Reply
  4. 05-21-2016, 10:07 PM #4
    asqtexture
    asqtexture is offline
    Registered User
    Join Date
    05-21-2016
    Location
    UYO
    MS-Off Ver
    2013
    Posts
    3

    Re: linking data between to sheets

    oeldere, thank you once again for the tip, it was really helpful.
    Reply With QuoteRegister To Reply
  5. 05-22-2016, 03:31 AM #5
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: linking data between to sheets

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

    It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
    Reply With QuoteRegister To Reply
  6. 05-23-2016, 03:40 AM #6
    Ramesh h&m
    Ramesh h&m is offline
    Forum Contributor
    Join Date
    03-28-2016
    Location
    india
    MS-Off Ver
    2013 (in 2023)
    Posts
    124

    Re: linking data between to sheets

    Hi pls help on below issue..

    I have a excel work book with 14 sheets and named as current date (23.05.16). The data's filled in 13 sheets combined in consolidation sheet placed as sheet 14. I need a excel report with cumulation of every day data (23.05.16 + 24.05.16 + 25.05.16....) how do i get?
    Reply With QuoteRegister To Reply
  7. 05-23-2016, 04:09 AM #7
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: linking data between to sheets

    @Ramesh h&m

    Please read the forumrules and act that way.

    2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.
    Reply With QuoteRegister To Reply
  8. 05-23-2016, 05:49 AM #8
    Ramesh h&m
    Ramesh h&m is offline
    Forum Contributor
    Join Date
    03-28-2016
    Location
    india
    MS-Off Ver
    2013 (in 2023)
    Posts
    124

    Re: linking data between to sheets

    Sorry.. i am new to forum. Meet you in new post. tks
    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. linking data on different sheets and on a graph
    By clovermarie85 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-04-2014, 04:29 AM
  2. Linking Data Between Sheets
    By Miki Lu in forum Excel General
    Replies: 4
    Last Post: 05-25-2013, 07:12 PM
  3. Linking data between sheets as it is added
    By nyeb44 in forum Excel General
    Replies: 5
    Last Post: 12-20-2012, 09:39 PM
  4. linking data on different excel sheets
    By generalfemi in forum Excel General
    Replies: 5
    Last Post: 02-08-2012, 11:26 AM
  5. Linking data from 2 sheets
    By josh-lucy in forum Excel General
    Replies: 1
    Last Post: 11-26-2011, 06:22 PM
  6. Linking data to multiple sheets
    By dklatt in forum Excel General
    Replies: 2
    Last Post: 04-24-2010, 12:25 PM
  7. linking data from multiple sheets
    By sjhonny in forum Excel General
    Replies: 3
    Last Post: 01-08-2007, 01:10 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