Improving a production workbook through vba to find and index operator information.

[PRD6]

I am currently trying to automate one of the reports we generate at the production facility I work at. Currently we hand type from spreadsheet document to another. What I would like to do is automate the function from within the original document.

*** I have to be vague as the information I am working with is proprietary ***

On the original document there are operator names in Cells B4, B7, B10, B13, B16, B19, B22, B25, B28, B31, B34, B37

After a production shift there are certain numbers we use to evaluate our operators. These numbers are located in the corresponding cells in Rows Q, R, and S.

What I would like to do is set up VBA to find report each instance of operator names with the corresponding cells from Q, R, and S. I would also like to include the date from the report if possible, which is in C1. The workbook is in set up in quarters, so there are a lot of sheets (1 for each day).

B4 = Operator Name Q4 = "a value" R4 = "a value" S4 = "a value"



Any help or ideas would be greatly apreciated. I can't use Vlookup due to the way the original document is structured.

Thanks,
PRD