Good evening,
I am trying to complete a small project and have run into a bit of an issue. I have one sheet that contains 7 columns and 100 rows. In this sheet I have employee name, job site, and hours for M-F. I have another sheet in the same workbook that allows the user to select the job site - what I would like to do is have the data in sheet 1 populate in sheet 2 if the job site in sheet 1 is the same as the selection in sheet 2.
Thank you in advance,
Diann
I am trying to complete a small project and have run into a bit of an issue. I have one sheet that contains 7 columns and 100 rows. In this sheet I have employee name, job site, and hours for M-F. I have another sheet in the same workbook that allows the user to select the job site - what I would like to do is have the data in sheet 1 populate in sheet 2 if the job site in sheet 1 is the same as the selection in sheet 2.
Thank you in advance,
Diann