Hello,
I have not found a solution yet that works.
I have a workbook where I am making a master sheet that calculates hours worked. On the master sheet there is a list of companies found in D2:D44 and an associate name in F1 , G1 H1 and I4. In cells F2:F44 (mirrored in G-I), I would like a formula that will search through all of the sheets where the company and associate are both found and return a total of hours worked.
On the sheets being searched through, the company name is in cell B4, the associate's name is in range A30:A34 and the hours worked are in range G30:G34.
All of the sheet names vary but I have entered in a "Start" and "End" sheet to help group all the sheets together.
I appreciate any and all help
I have not found a solution yet that works.
I have a workbook where I am making a master sheet that calculates hours worked. On the master sheet there is a list of companies found in D2:D44 and an associate name in F1 , G1 H1 and I4. In cells F2:F44 (mirrored in G-I), I would like a formula that will search through all of the sheets where the company and associate are both found and return a total of hours worked.
On the sheets being searched through, the company name is in cell B4, the associate's name is in range A30:A34 and the hours worked are in range G30:G34.
All of the sheet names vary but I have entered in a "Start" and "End" sheet to help group all the sheets together.
I appreciate any and all help