Sherman On Excel and BI Technology

PingBack from http://www.fuzzlinks.com/2008/07/13/sherman-on-excel-and-bi-technology-excel-services-charting-and-visual-analysis/

I am working on a project that requires pulling the data from a spreadsheet cell and inserting

That data into a document that can summarize each spreadsheet's entry.

The documents are procurement department Request for Quote spreadsheets that are emailed

To potential suppliers, who then enter part number price information and return the speadsheets

Back the procurement agent. If the Supplier is unable to provide a price quote, there is a cell

Labeled Supplier Comments on the spreadsheet where the Supplier is to enter a reason for not

being able to submit a price quote. For instance, 'Unable to machine forged titanium'.

These price quote spreadsheets are saved to one networked folder.

I need to be able to pull the data from each spreadsheet to a summarizing document.

Is it possible to pull data from spreadsheets in a central location like this?

I would really appreciate any insight or information referral you could give me.

Thanks, Dan