| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup from External Reference File
I have a file I use for reference in generating the headings for my excel
reports. The reference file is currently in excel, but it as easily be in Access. The data contains the project number (used for lookup), description, etc. I create several report workbooks for a given project, several of which contain multiple sheets. I would like to be able to use the reference file to insert several pieces of project info into the individual reports. I have searched the threads and cannot find anything that works. This ROOKIE needs some direction. Thanks -- VBA Rookie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lookup from External Reference File
worksheets("Report1").Range("B9").Value =
Worksheets("ProjectInfo").Range("F11").value -- Regards, Tom Ogilvy "Bruce" wrote in message ... I have a file I use for reference in generating the headings for my excel reports. The reference file is currently in excel, but it as easily be in Access. The data contains the project number (used for lookup), description, etc. I create several report workbooks for a given project, several of which contain multiple sheets. I would like to be able to use the reference file to insert several pieces of project info into the individual reports. I have searched the threads and cannot find anything that works. This ROOKIE needs some direction. Thanks -- VBA Rookie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate path and file string for external reference | Excel Worksheet Functions | |||
| reference to an external file | Excel Discussion (Misc queries) | |||
| how to call a reference to a cell in external file | Excel Worksheet Functions | |||
| external reference to file in the same folder | Excel Discussion (Misc queries) | |||
| How do I reference external data from a file, file name found in . | Excel Discussion (Misc queries) | |||
Linear Mode
