having two books talk to each other

mpreyss

New Member
Joined
Nov 22, 2005
Messages
1
i have two books for work. the first is an excel file with a list of all the items we have sold, who purchased them, what date and for how long. the second is an excel file that lists bonus for sales. i want to have the bonus excel file pull the information from the master list excel file so the bonus is updated automatically.

here's an example:
Master List
product / product type / cust. name / date of purchase
1 / a / john doe / 11-1-2005
2 / b / jane doe / 11-2-2005
3 / c / homer simpson / 11-10-2005

Bonus File
Week Ending: 11-07-2005
product / product type / cust. name / date of purchase
1 / a / john doe / 11-1-2005
2 / b / jane doe / 11-2-2005

so bonus payouts are based on the product being sold during the week but one file needs to recognize the other and pull that information. to make it complicated, all the units to sell are preselected and slotted. so john doe above who bought product 1a is the only person who can purchase 1a, the next person may purchase 1b or 1c or 2a or 45d but no one can purchase the same product as john doe. so the Master List reads something like:

product product type cust. name date of purchase
1 a john doe 11-1-2005
1 b AVAILABLE
2 a AVAILABLE
2 b jane doe 11-2-2005
etc.
 

Forum statistics

Threads
1,078,373
Messages
5,339,814
Members
399,330
Latest member
mallikharjun

Some videos you may like

This Week's Hot Topics

Top