Results 1 to 3 of 3

Thread: Reference to Data of a cell from another excel sheet - Increment Automatically
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2018
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Reference to Data of a cell from another excel sheet - Increment Automatically

    Hello Sirs,


    I have an excel file as log showing the details of drawings received - such as Reference Number, Attachments details & Drawing Titles etc. (Say the file name name as "Register1").


    I wanted to make transmittal for each item in another excel file (say file name as "Transmittal1").


    So once i linked a cell in "Transmittal1" file =[Register1.xlsx]Sheet1!$A$1, i need to update next two cells of "Transmittal1" file with the corresponding data from "Register1" file.


    If i copy paste manually it will be =[Register1.xlsx]Sheet1!$B$1 & =[Register1.xlsx]Sheet1!$C$1.


    But is there a way to have these two data automatically while i link the first cell?


    Note: The cells in "Transmittal1" are not in right order and not aligned to drag by removing the "$".


    Register1
    Doc No Attachment Title
    PIC-P2B-OGE-KME-TS-0375 1 Water Supply Layout



    Transmittal1
    Doc No
    PIC-P2B-OGE-KME-TS-0375
    Attachment
    1 Title
    Water Supply Layout





    Thank you,
    Mathew

  2. #2
    New Member
    Join Date
    Jun 2018
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reference to Data of a cell from another excel sheet - Increment Automatically

    Hello ..can anyone help with this one please??
    Thank you

  3. #3
    New Member
    Join Date
    Jun 2018
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Reference to Data of a cell from another excel sheet - Increment Automatically

    Hello, Can anyone please help on this?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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