I need help...................
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: I need help...................

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm pretty to Excel. I have two workbooks....one has Admitting data in it and the other is discharge data.

    I want to be able to type in the information info in to the admit sheet (patient number, name, etc.)

    Then, when I open the Discharge sheet and input the patient name I would like to have it pull the data over from the Admitting sheet, so I don't have to input duplicate information.

    Can someone please help me with this?

  2. #2
    Guest

    Default

    Hi WildDaisy

    To get you started, try the VLOOKUP formula
    Create 2 workbooks. Name one ADMIT and the other DISCHARGE
    Put these details in the first 4 columns of ADMIT in Sheet1
    A B C D
    Patient No Name Address Age
    1 Jim road 20
    2 Fred street 30
    3 Pete lane 40
    4 Meg avenue 50

    Put these details in the first 4 columns of DISCHARGE in Sheet1
    A B C D
    Patient No Name Address Age
    1
    2
    3
    4

    In Sheet1 of DISCHARGE, select cell B2 and carry out this procedure
    type =VLOOKUP(
    Select cell A2 notice in the command line that this has added A2 to your formula
    Press F4 on your keyboard 3 times till the A2 in your formula becomes $A2
    (the $ before the column A keeps your formula fixed to that column when you scroll it )
    type a comma
    Select ADMIT, Sheet1 and the whole range from A2 to D5
    ( notice in the command line this has added your array
    as an absolute reference - ie both row and column are preceded by $)
    type a comma
    type: 2 this designates that you want data returned from column 2 or your array
    type a comma
    type: False this allows a search of the patient number even if they are not in sequence and returns error is match not found.
    type: )
    Immediately press enter.
    You now have the following formula =VLOOKUP($A2,[Admit.xls]Sheet1!$A$2:$D$5,2) in cell B2
    Now Select B2
    Put your cursor over the bottom right corner of this cell till the pointer becomes a black cross
    Hold down left mouse and drag right to cell D2
    Select cell C2 and change the last 2 in the formula to 3 (to get data from column 3). PRESS ENTER
    Select cell D2 and change the last 2 in the formula to 4 (to get data from column 4) PRESS ENTER
    Select range B2:D2
    Put your cursor over the bottom right corner of this range till the pointer becomes a black cross
    Hold down left mouse and drag down to cell D5

    By using the patient number as a reference you have now obtained data from the ADMIT sheet.

    Read the Help file on VLOOKUP and you will soon be an expert.

    Good luck
    Derek

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wilddaisy
    That's me (didn't mean to post as anonymous
    Derek

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank you so much! That worked perfectly.

User Tag List

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
  •  

 

 
DMCA.com