+ Reply to Thread
Results 1 to 4 of 4

Copying selective data from sheet2 to sheet1 based on the selection made in sheet1.

  1. #1
    Registered User
    Join Date
    07-16-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Copying selective data from sheet2 to sheet1 based on the selection made in sheet1.

    Hi,
    Its been quite some time that I have visited this site. been preoccupied with other assignment at hospital.

    I would seek your help in solving this situation, required in managing Turn around time in the laboratory.

    I have an excel sheet (OfficeXP/Office 2003), where in Sheet1, I enter certain data like a test name from a drop down list (saved in Sheet2). Once the name is selected, I need few additional data adjacent to test names in Sheet-2 to be copied in the respective columns in Sheet-1.

    Example, Pl see the attached workbook.

    Sheet-2
    Col A=Test name B=Instrument C=Time in minutes
    Row 1. A=Glucose B=Siemens C=10
    Row 2. A=Tot. Prot B=Siemens C=10
    Row 3. A=Albumin B=Siemens C=15
    Row 4. A=DC B=Beckman C=22
    Row 5. A=Electrophoresis B=Sebia C=15
    Row 6. A=Immunoglobulins B=Vitrous C=30

    Sheet-1
    A= S.No., B=Pat Name, C=Pat ID, D=Test requested (as drop down menu from sheet2), E= Sample Col Time & F=Report deliver time (this will be calculated as E+20(for sample processing)+Sheet2!C - corresponding to the test requested).


    What I would require is, once the test name is selected, then Col F should also get updated. Col E will be updated using IF & time function.

    Will this require any macro or can be done using function formula?

    Appreciate your support and any suggestions in this regard.
    Thanks in advance.
    Regards
    Daavis

    The attached workbook:
    TAT calculation.xls

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,558

    Re: Copying selective data from sheet2 to sheet1 based on the selection made in sheet1.

    Put this formula in F2:

    =E2+TIME(0,20,0)+TIME(0,VLOOKUP(D2,Sheet2!$A$2:$C$17,3,0),0)

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-16-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Copying selective data from sheet2 to sheet1 based on the selection made in sheet1.

    Quote Originally Posted by Pete_UK View Post
    Put this formula in F2:

    =E2+TIME(0,20,0)+TIME(0,VLOOKUP(D2,Sheet2!$A$2:$C$17,3,0),0)

    Hope this helps.

    Pete
    Thanks Pete for the prompt response. Your information very well served my purpose. Thanks once again.


    NB: Seems you live in an Excel world, saw your contribution in almost all the threads before i posted mine....and also hoped that you will answer to mine as well. It came true.
    Keep up the good work and also to the forum, for providing such benefits.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,558

    Re: Copying selective data from sheet2 to sheet1 based on the selection made in sheet1.

    Glad to be of help - thanks for feeding back.

    Pete

+ 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