Help Please! (This one is a bit tricky)

[Dean Goodmen]

I need to look up a cell value from another workbook. Here is what I
have :

Work sheet One at C:\folder1\workbook1
Work sheet Two at C:\folder2\workbook2 (name varies)

In work book one, I need to assign Cell B2 to a cell value found
in Wookbook 2. Here is the catch... The name of work book2 is
depentant on the date in Workbook1 and as well as the sheet name, and
I also need to FIND the cell.

For instance in workbook1 : Cell A1 = 03/01/05
To find the value of B2 I need to find it below
So the name of work book 2 would be backup05 (Backup/YEAR/)
Looking at sheet name 03-05 (MM-YY)
Find the word "Backupvalue" in Colloum1 The cell just to the right of
that word would be the value to send back to workbook1, cell B2

I hope this all makes sence LOL

Thanks,
Ed

 

[Chip]

Well I would need to know the path for backup05, or the user would have
to find the file themselves.

 

[Dean Goodmen]

Well I would need to know the path for backup05, or the user would have
to find the file themselves.

That would be WorkBook2


Work sheet One at C:\folder1\workbook1
Work sheet Two at C:\folder2\workbook2 (name varies)