How do I tell excel to find a cell value from a folder of files by giving it
part of the filename and link that value to a master workbook?

"Kaby" wrote:

How do I tell excel to find a cell value from a folder of files by giving it
part of the filename and link that value to a master workbook?

HI, i'm not to sure what you are asking, if you wish to display a value in one cell that is on another worksheet or work book you just need to type = in the formula box and then navigate to the cell you wish to link, then press enter.

If you want to link to a file or folder you need to use a hyperlink. The
important thing to remember with this is that if you are emailing the file
this link will be broken if the recipient does not have the file saved
locally in the same place, of if it is not shared on a network.

Thanks for the hint John...I will look to see if I can figure this hyperlink
function out.

To give you more on what I am trying to do, I have workbooks that are being
created from time to time depending on the actual product. In other words
each product will have its own workbook with its own name. What I want to be
able to do is extract certain data from those workbooks that are being
created into a master workbook. In the master workbook, I plan to have a
column that has part or all of the file name. What I want excel to do is
look through those files, which will be stored in a specific folder, and
choose and open the corresponding workbook and retrive cell values into the
master workbook.

I hopw this makes sense...

"John Hodgson" wrote:



"Kaby" wrote:

How do I tell excel to find a cell value from a folder of files by giving it
part of the filename and link that value to a master workbook?

HI, i'm not to sure what you are asking, if you wish to display a value in one cell that is on another worksheet or work book you just need to type = in the formula box and then navigate to the cell you wish to link, then press enter.

If you want to link to a file or folder you need to use a hyperlink. The
important thing to remember with this is that if you are emailing the file
this link will be broken if the recipient does not have the file saved
locally in the same place, of if it is not shared on a network.

Two things I should add is that I don't want to go to (or open) the source
file, which is what hyperlink seems to do; I just want the value to show up
in the destination file. Further, the thing that is throwing me off is that
I don't know the file names before hand. I am trying to avoid the product
managers from entering same information in two places.

Somehow, I feel like I am not making sense...



"Kaby" wrote:

Thanks for the hint John...I will look to see if I can figure this hyperlink
function out.

To give you more on what I am trying to do, I have workbooks that are being
created from time to time depending on the actual product. In other words
each product will have its own workbook with its own name. What I want to be
able to do is extract certain data from those workbooks that are being
created into a master workbook. In the master workbook, I plan to have a
column that has part or all of the file name. What I want excel to do is
look through those files, which will be stored in a specific folder, and
choose and open the corresponding workbook and retrive cell values into the
master workbook.

I hopw this makes sense...

"John Hodgson" wrote:



"Kaby" wrote:

How do I tell excel to find a cell value from a folder of files by giving it
part of the filename and link that value to a master workbook?

HI, i'm not to sure what you are asking, if you wish to display a value in one cell that is on another worksheet or work book you just need to type = in the formula box and then navigate to the cell you wish to link, then press enter.

If you want to link to a file or folder you need to use a hyperlink. The
important thing to remember with this is that if you are emailing the file
this link will be broken if the recipient does not have the file saved
locally in the same place, of if it is not shared on a network.

hello kaby:

i think i understand your problem. do you know any VBA, only a little
would be necessary? there is a solution, but it would require a some VBA.

reply to this thread and i can give you code examples for how to perform this.

cheers. chili.

"Kaby" wrote:

Two things I should add is that I don't want to go to (or open) the source
file, which is what hyperlink seems to do; I just want the value to show up
in the destination file. Further, the thing that is throwing me off is that
I don't know the file names before hand. I am trying to avoid the product
managers from entering same information in two places.

Somehow, I feel like I am not making sense...



"Kaby" wrote:

Thanks for the hint John...I will look to see if I can figure this hyperlink
function out.

To give you more on what I am trying to do, I have workbooks that are being
created from time to time depending on the actual product. In other words
each product will have its own workbook with its own name. What I want to be
able to do is extract certain data from those workbooks that are being
created into a master workbook. In the master workbook, I plan to have a
column that has part or all of the file name. What I want excel to do is
look through those files, which will be stored in a specific folder, and
choose and open the corresponding workbook and retrive cell values into the
master workbook.

I hopw this makes sense...

"John Hodgson" wrote:



"Kaby" wrote:

How do I tell excel to find a cell value from a folder of files by giving it
part of the filename and link that value to a master workbook?

HI, i'm not to sure what you are asking, if you wish to display a value in one cell that is on another worksheet or work book you just need to type = in the formula box and then navigate to the cell you wish to link, then press enter.

If you want to link to a file or folder you need to use a hyperlink. The
important thing to remember with this is that if you are emailing the file
this link will be broken if the recipient does not have the file saved
locally in the same place, of if it is not shared on a network.

I know little VBA...Alt-F11 to get to it right...

"thechilipino" wrote:

hello kaby:

i think i understand your problem. do you know any VBA, only a little
would be necessary? there is a solution, but it would require a some VBA.

reply to this thread and i can give you code examples for how to perform this.

cheers. chili.

"Kaby" wrote:

Two things I should add is that I don't want to go to (or open) the source
file, which is what hyperlink seems to do; I just want the value to show up
in the destination file. Further, the thing that is throwing me off is that
I don't know the file names before hand. I am trying to avoid the product
managers from entering same information in two places.

Somehow, I feel like I am not making sense...



"Kaby" wrote:

Thanks for the hint John...I will look to see if I can figure this hyperlink
function out.

To give you more on what I am trying to do, I have workbooks that are being
created from time to time depending on the actual product. In other words
each product will have its own workbook with its own name. What I want to be
able to do is extract certain data from those workbooks that are being
created into a master workbook. In the master workbook, I plan to have a
column that has part or all of the file name. What I want excel to do is
look through those files, which will be stored in a specific folder, and
choose and open the corresponding workbook and retrive cell values into the
master workbook.

I hopw this makes sense...

"John Hodgson" wrote:



"Kaby" wrote:

How do I tell excel to find a cell value from a folder of files by giving it
part of the filename and link that value to a master workbook?

HI, i'm not to sure what you are asking, if you wish to display a value in one cell that is on another worksheet or work book you just need to type = in the formula box and then navigate to the cell you wish to link, then press enter.

If you want to link to a file or folder you need to use a hyperlink. The
important thing to remember with this is that if you are emailing the file
this link will be broken if the recipient does not have the file saved
locally in the same place, of if it is not shared on a network.