link two spreadsheets

[Mktg Mgr]

We do monthly sales reports by sales person/by item. I have another
spreadsheet that lists the certain items that pay a bonus back to the
sales rep. This changes several times throughout the year. How do I
"combine" the two so that the items sold will automatically list the
bonus if there is a bonus to be paid?

 

[JE McGimpsey]

We do monthly sales reports by sales person/by item. I have another
spreadsheet that lists the certain items that pay a bonus back to the
sales rep. This changes several times throughout the year. How do I
"combine" the two so that the items sold will automatically list the
bonus if there is a bonus to be paid?

You don't give nearly enough information on how your data is laid out
for someone to give you a good answer.

Where do you want to list the bonus - on the bonus sheet or on each
worksheet?

By "another spreadsheet" do you mean another worksheet in the same
workbook, or another workbook?

What is the "this" that changes throughout the year?

How will XL know how much bonus is attached to each item? Does the bonus
change based on cumulative sales?

Are you looking for a cumulative bonus? or a bonus for sales within a
certain time period? Will the worksheets be used for this bonus period
only, or does the calculation need to exclude sales outside the period?