Search Across Worksheets, Copy to Another Worksheet?

cjbyf

New Member
Joined
Jan 15, 2004
Messages
16
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
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,130,045
Messages
5,639,751
Members
417,108
Latest member
Thein Than

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top