Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|