Without knowing how your files are structured it's impossible to say with
certainty, but it's probably something that can be done - if you have an ID
or other unique way to identify each employee, and that ID appears in both
workbooks


"SGT Buckeye" wrote:

I am trying to import data from a workbook created by our IS team into
my workbook which calculates the sales bonus of my employees.
Currently, I manually enter their sales numbers. The problem is I am
duplicating efforts because the IS workbook already has the numbers I
need. In fact, it is where I get the numbers to input into my
workbook. Can I set up some kind of lookup function/formula to bring
in the data I need so that I don't have to manually enter it everyday?
Also, you may need to know that when I open the IS workbook, I have to
click on an update button in order to get the latest data.