Results 1 to 2 of 2

Thread: integrating find tool in a cell referring another workbook in MS-excel 2007

  1. #1
    Join Date
    Apr 2012
    Posts
    2

    question integrating find tool in a cell referring another workbook in MS-excel 2007

    hi everyone! is it possible to integrate the "Find" tool in cells of a worksheet when its reference are the worksheets of another workbook and automatically display the detail of it. e.g. workbook1 is the reference which have 3 worksheets wherein have a unique item name w/ its corresponding description; workbook2 is composed also of classified worksheets in which during type completion of the item name the description will automatically display on its corresponding cell.

  2. #2
    Join Date
    Jan 2006
    Posts
    605

    Re: integrating find tool in a cell referring another workbook in MS-excel 2007

    You can create an external reference between cells in different workbooks by following the below method:
    1. Open the workbook that will contain the external reference (the destination workbook) and the workbook that contains the data that you want to link to (the source workbook).
    2. In the source workbook, click Save on the Quick Access Toolbar.
    3. Select the cell or cells in which you want to create the external reference.
    4. Type = (equal sign). If you want to perform calculations or functions on the external reference value, type the operator or function that you want to precede the external reference.
    5. Switch to the source workbook, and then click the worksheet that contains the cells that you want to link to.
    6. Select the cell or cells that you want to link to.
    7. Return to the destination workbook, and notice that Excel adds the reference to the source workbook and the cells that you selected in the previous step.
    8. Optionally, in the destination worksheet, edit or change the formula.
    9. Press CTRL+SHIFT+ENTER.

Similar Threads

  1. Embedded Excel 2007 workbook gives error in Word 2007.
    By Milo D in forum Windows Software
    Replies: 5
    Last Post: 25-04-2011, 06:26 AM
  2. How do I protect a Workbook on Excel 2007?
    By Coquidragon in forum Windows Software
    Replies: 2
    Last Post: 04-09-2009, 10:31 AM
  3. Workbook is not displaying in Excel 2007
    By Paisley007 in forum Windows Software
    Replies: 3
    Last Post: 29-08-2009, 07:02 PM
  4. Need help in Saving an Excel 2007 Macro-Enabled Workbook
    By Mega mind in forum Windows Software
    Replies: 5
    Last Post: 06-08-2009, 08:13 AM
  5. How can i protect a workbook in Excel 2007
    By stephenx in forum Windows Software
    Replies: 2
    Last Post: 30-04-2009, 05:31 PM

Tags for this Thread

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
  •  
Page generated in 1,638,937,238.88377 seconds with 17 queries