Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2007
    Location
    La Jolla, California, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking template form to one or more worksheets (Excel 2007)

    I'm using Excel 2007. Using one of Excel's Purchase Order template forms, how do I link this template form to one or more worksheets so when I fill out the cells in the template form it throws those values into one or more worksheets?

    Thank you!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking template form to one or more worksheets (Excel 2007)

    You can use formulas to link cells on other sheets to cells on the purchase order sheet.

    For example, let's say that you want the Line Total from cell G20 on the Purchase Order sheet to be copied to a cell on another sheet.
    Select that cell.
    Type =
    Click on the sheet tab of the Purchase Order sheet.
    Click on cell G20.
    Press Enter or click the green check mark in the formula bar.
    You have created the following formula:
    <code>
    ='Purchase Order'!G20
    </code>
    If desired, you can fill this formula down to cells below.

Posting Permissions

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