Hi All!
We are working on a sheet and want to pull data from sheet 2 based on the date entered on sheet 1 cell A1.
The data is arranged on sheet 2 by date. Each cloumn is a different date containing either a staff name in the rows below or off. These are list across 31 columns.
In each row...