Lauster_1999
New Member
- Joined
- Mar 28, 2002
- Messages
- 1
I am working on a school project on Excel 2000 and i am wanting to lookup values from one workbook and copy them across to another. However the system is quite complex. I have a mail-order company with four different order methods-Phone,Fax,Email and Regular mail.On my sales workbook, I have a list of all the invoice details, including order method and order total and many other order details. However I want to create a summary sheet on a seperate workbook, which will lookup the sales values in the sales workbook and sum up the values for each seperate order method. I know there must be some processing between the vlookup and the raw data, but i dont know how to process this and i am unsure of the code for the vlookup. Can someone explain if there is a solution to this problem?