Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use lookup results from closed workbook in page header.
Hi,
I am using Excel 2003. I would like a macro to vlookup data from a closed workbook that changes the end its name such as c:\Recent\Reports for Williams.xls (or Reports for Smith.xls). I'd like to look in column 2 of Reports for ??? workbook and if the data in column 2 is contained anywhere cell "D2" of my existing open workbook, I'd like to return the same row's data that's located in column "E" of the Reports for ??? workbook to be placed as the center header for my existing workbook. Thanks in advanced -- By persisting in your path, though you forfeit the little, you gain the great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create overview page; lookup results from multiples worksheet | Excel Worksheet Functions | |||
Lookup last used Row un closed Workbook | Excel Worksheet Functions | |||
Printing a workbook but not getting page set-up results | Excel Discussion (Misc queries) | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Can a header be applied once to a workbook & print on each page? | Excel Worksheet Functions |