| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inport from a variable file name
I have a sheet that I need to import information from a separate file, however the separate file is saved under a different name each time. More specifically it is an invoice that is saved under the project number (ex: 06252.xls), on the spreadsheet I need to import certain cells based on the project number which is in column A of the spreadsheet. I can use the "lookup" function to import opposite of what I would like (spreadsheet to invoice, vs invoice to spreadsheet) however the boss says that he would prefer it the other way....ugh. :) I'm not sure if it is possible, but if anyone has any suggestions of a good way to do this I would appreciate it. -- shikamikamoomoo ------------------------------------------------------------------------ shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018 View this thread: http://www.excelforum.com/showthread...hreadid=525044 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inport from a variable file name
I found what I needed...thanks anyhow  -- shikamikamoomoo ------------------------------------------------------------------------ shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018 View this thread: http://www.excelforum.com/showthread...hreadid=525044 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Excel file automatically opens | Excel Discussion (Misc queries) | |||
| copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Hybrid Mode
