external data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to import cell values of multiple workbooks in a folder based
on a date contained in these workbooks? I would like to import the name and
the dollar amount of each contract based on each workbooks scheduled date.
 
I may not be following this completely; but, it seems me that you would want
this as a list stored like a database. Use Data|Form in Excel to do the entry
and retrieval. It sounds like each contract is being stored in its own
workbook.

P.
 

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

extract from multiple workbooks in a folder 8
Extract cell data from multiple files in one folder 3
Compile report from multiple workbooks 6
Sum based on date in another cell 5
summarizing data from various workbooks 3
formula between two workbooks 1
consolidate workbooks to worksheets in one workbook? 1
Named Range: Same Names, Multiple Workbooks with Same Sheet Name 4

Back
Top