+ Reply to Thread
Results 1 to 4 of 4

Need to always pull info from same line in a different worksheet?

  1. #1
    Registered User
    Join Date
    05-25-2011
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Need to always pull info from same line in a different worksheet?

    My veterinary hospital is doing a big rabies vaccination clinic in a few weeks, and I have created an excel workbook to house all of the information. What I have going is 2 worksheets in 1 workbook, using Excel 2003. Worksheet 1 ("Info"), is where I'll log all of the owner and pet's info. Worksheet 2 ("Certificate") is where I will pull the line info from "Info" to quickly create a printable rabies certificate to give to the owner. What I would like for excel to do is always pull the info from line 2 in "Info" to fill in the blanks on "Certificate". My vision is to always plug the current info into line 2 (I will add a line after each entry, so that I am always entering on line 2). The problem that I am running in to is that on "Certificate", no matter if I make it absolute, or lock the cells, it always follows the line I just entered (if I add a new line and the original info is now on line 3, it pulls from line 3). Does anyone have any idea how to lock it between worksheets so that it always uses the info on line 2 no matter where the original info goes? I included my file for you to look at. I am extremely frustrated and have searched online for answers and can't find them. Please help!

    Thank you!
    Jennifer

    Copy of Rabies Certificates.xls
    Last edited by goldie91486; 05-25-2011 at 04:15 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Need to always pull info from same line in a different worksheet?

    One simple way is to use the INDIRECT Function. So for example, B19, the pet name will be

    =INDIRECT("Info!F2")
    you need the quotes. Then the F2 will not change when you insert a new row.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Need to always pull info from same line in a different worksheet?

    Another more efficient way is using INDEX like so

    =INDEX(Info!$F$1:$F$3,2)
    As you insert rows, that range will increase (i.e F1:F4, F1:F5) but it will always return the value from row 2 (F2).

  4. #4
    Registered User
    Join Date
    05-25-2011
    Location
    Asheville, NC
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Need to always pull info from same line in a different worksheet?

    Wow! After a week of trying to figure this out... YOU SOLVED IT! I can't thank you enough!!

+ 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