Inport from a variable file name

  • Thread starter Thread starter shikamikamoomoo
  • Start date Start date
S

shikamikamoomoo

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 projec
number (ex: 06252.xls), on the spreadsheet I need to import certai
cells based on the project number which is in column A of th
spreadsheet. I can use the "lookup" function to import opposite o
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
good way to do this I would appreciate it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot tables 1
Export data from the same cell from multiple spreadsheets into a n 1
Access Access variable string for export 0
matching a column of numbers to another in another spreadsheet 1
Formula Help 3
Data Validation to exclude blank cells 6
How do I write to a closed work book as a "register" 1
Find partial match from column A,B and fill partial match in C? 4

Back
Top