Is this possible with Excel alone?
 

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

Is this possible with Excel alone?
 

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
--
HTH...

Jim Thomlinson


"KeithJ" wrote:

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

Is this possible with Excel alone?
 

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

KeithJ

"Jim Thomlinson" wrote:

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
--
HTH...

Jim Thomlinson


"KeithJ" wrote:

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

Is this possible with Excel alone?
 

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



"KeithJ" wrote:

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