How to link pick values from one work book and transfer to anoter.

K

Kay Cee

I have a work sheet( work book 1) which has employee number(ID) and hours
budgeted each week. I get another report ( work book 2)with employee hours
spent each week. Employees on job keeps coming in and out every week. further
second work book is formatted differently( by department and location etc)
To track what is spent by each employee, I want to pick from work book 2 and
list hours spent against budget in work book 1.
sorting and pasting does not help as sequence is not same in work book 2
every week.
I want to use employee ID to search and pick values from work book 2 every
week and place these values against same ID in work book 1
 
F

Frank Kabel

Hi
have a look at either VLOOKUP or SUMIF. You may also provide some more
details about the data in workbook 2 (example data) and what you want
to return (only a single value or a sum)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summarizing multiple worksheet data 0
Auto populate value from one task to another in MS PROJECT 0
Formula to sum based on a change in another column 2
Transfering information form one cell to another work sheet 14
conditional if loop 0
Compute Additional Hours Needed Using "if" or "lookup" 1
Assigning a value to one cell based on the date in another... And then doing it again 0
How to constraint parallel tasks execution 0

Top