Search Different Excel Sheets
 

Our company creates an excel spreadsheet for each time we work with one
of our customers. Each spreadsheet is identical but has different
information filled on it. needless to say we have thousands of excel
documents. we name our documents name-date-invoicenumber.xls

everything works perfect and we don't want to change our processes,
but it would be nice to be able to search and total a certain field in
the files for a date range. is this possible? how?

Thank You

Search Different Excel Sheets
 

Anyone?


wrote:
Our company creates an excel spreadsheet for each time we work with one
of our customers. Each spreadsheet is identical but has different
information filled on it. needless to say we have thousands of excel
documents. we name our documents name-date-invoicenumber.xls

everything works perfect and we don't want to change our processes,
but it would be nice to be able to search and total a certain field in
the files for a date range. is this possible? how?

Thank You