Is this possible with Excel alone?

[KeithJ]

I am looking to enhance my current quote system and make it Excel based.
What I want to do is extract the information from the quotes and summarise it
in an overall quote summary workbook. Can this be done automatically from
all quotes in a folder?

Thanks,

KeithJ

 

[Jim Thomlinson]

That is possible. While my prefernce for doing that kind of thing is a
database what you are asking is possible. Check out this link and look for
Merge Data from All Workbooks...

http://www.rondebruin.nl/tips.htm

 

[KeithJ]

Thanks for the help Jim I'll check it out.

KeithJ

 

[CLR]

Yes, it can be done in Excel, with macros.........to facilitate, each
individual quote should be done to a master template, thereby Excel will know
where to find each answer it seeks........

Vaya con Dios,
Chuck, CABGx3