+ Reply to Thread
Results 1 to 4 of 4

How do I use a cell value as the filename in an external link?

  1. #1
    Dave Peterson
    Guest

    Re: How do I use a cell value as the filename in an external link?

    You have one reply to your post in .misc.

    wattkisson wrote:
    >
    > I want to set up a workbook with several values from linked workbooks. I
    > would like to enter a value in column A and then use that value as the
    > filename in the rest of the cells that link to the external workbook.
    > For example:
    >
    > I want to enter A122 into colum A - and have the cell in column B pick that
    > value up and link to a cell in an external workbook with that name
    >
    > Obviously, the following function links correctly to the external file and
    > returns the correct value:
    > ='G:\Local files\Sample Tracking\[A122.xls]Sample Request'!$E$2
    >
    > But, I do not want to have to change the syntax in a large number of cells
    > everytime I add to the list. I only want to enter the value (A122) in the
    > first cell and have the others retrieve linked values correctly.
    > In other words, I want a dynamic, external link.
    >
    > Thanx in advance for any help.


    --

    Dave Peterson

  2. #2
    Dave Peterson
    Guest

    Re: How do I use a cell value as the filename in an external link?

    You have one reply to your post in .misc.

    wattkisson wrote:
    >
    > I want to set up a workbook with several values from linked workbooks. I
    > would like to enter a value in column A and then use that value as the
    > filename in the rest of the cells that link to the external workbook.
    > For example:
    >
    > I want to enter A122 into colum A - and have the cell in column B pick that
    > value up and link to a cell in an external workbook with that name
    >
    > Obviously, the following function links correctly to the external file and
    > returns the correct value:
    > ='G:\Local files\Sample Tracking\[A122.xls]Sample Request'!$E$2
    >
    > But, I do not want to have to change the syntax in a large number of cells
    > everytime I add to the list. I only want to enter the value (A122) in the
    > first cell and have the others retrieve linked values correctly.
    > In other words, I want a dynamic, external link.
    >
    > Thanx in advance for any help.


    --

    Dave Peterson

  3. #3
    wattkisson
    Guest

    How do I use a cell value as the filename in an external link?

    I want to set up a workbook with several values from linked workbooks. I
    would like to enter a value in column A and then use that value as the
    filename in the rest of the cells that link to the external workbook.
    For example:

    I want to enter A122 into colum A - and have the cell in column B pick that
    value up and link to a cell in an external workbook with that name

    Obviously, the following function links correctly to the external file and
    returns the correct value:
    ='G:\Local files\Sample Tracking\[A122.xls]Sample Request'!$E$2

    But, I do not want to have to change the syntax in a large number of cells
    everytime I add to the list. I only want to enter the value (A122) in the
    first cell and have the others retrieve linked values correctly.
    In other words, I want a dynamic, external link.

    Thanx in advance for any help.

  4. #4
    Dave Peterson
    Guest

    Re: How do I use a cell value as the filename in an external link?

    You have one reply to your post in .misc.

    wattkisson wrote:
    >
    > I want to set up a workbook with several values from linked workbooks. I
    > would like to enter a value in column A and then use that value as the
    > filename in the rest of the cells that link to the external workbook.
    > For example:
    >
    > I want to enter A122 into colum A - and have the cell in column B pick that
    > value up and link to a cell in an external workbook with that name
    >
    > Obviously, the following function links correctly to the external file and
    > returns the correct value:
    > ='G:\Local files\Sample Tracking\[A122.xls]Sample Request'!$E$2
    >
    > But, I do not want to have to change the syntax in a large number of cells
    > everytime I add to the list. I only want to enter the value (A122) in the
    > first cell and have the others retrieve linked values correctly.
    > In other words, I want a dynamic, external link.
    >
    > Thanx in advance for any help.


    --

    Dave Peterson

+ 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