ExcelBanter - View Single Post

[email protected]

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