Relative Newbie here with a problem. If someone can provide a solution great, but if I can figure out in excel-speak what I'm trying to do I am happy to self learn.
Here is a simplified version of what I have:
All in the same workbook, a series of worksheets each dated for all the days of the year. In these, I run a dialy web query to obtain data. No problem there.
Now I also have set up a worksheet for each employee. What I want to do is set up a way inside the employees worksheet to search through all the worksheets (days of the year) If the employee is listed on that particular day, there will be a corresponding sales figure directly one cell to the right of there name. I would like to be able search and then copy the sales figure directly into the employee worksheet. In excel terms what am I trying to do.
I am sure this is simple (for someone) just not sure what it's called.
Appreciate any help.
Chris
Here is a simplified version of what I have:
All in the same workbook, a series of worksheets each dated for all the days of the year. In these, I run a dialy web query to obtain data. No problem there.
Now I also have set up a worksheet for each employee. What I want to do is set up a way inside the employees worksheet to search through all the worksheets (days of the year) If the employee is listed on that particular day, there will be a corresponding sales figure directly one cell to the right of there name. I would like to be able search and then copy the sales figure directly into the employee worksheet. In excel terms what am I trying to do.
I am sure this is simple (for someone) just not sure what it's called.
Appreciate any help.
Chris