Hi
I have a workbook with 19 worksheets containing product information and when it was actually picked at the work place.
The data is consistent on every sheet running through columns A2 to G2. The data may run up to 65,000 rows.
The employee's (picker) name is in column E of every sheet.
Based on selecting an employee's name from a data validation drop down list I would like to extract the information from the 19 sheets and for them to appear in chronological order thus displaying the date and time order that the different products were picked.
Ideally this information is to be displayed on the same sheet as the drop down list.
Can anyone please help with this query?
I have a workbook with 19 worksheets containing product information and when it was actually picked at the work place.
The data is consistent on every sheet running through columns A2 to G2. The data may run up to 65,000 rows.
The employee's (picker) name is in column E of every sheet.
Based on selecting an employee's name from a data validation drop down list I would like to extract the information from the 19 sheets and for them to appear in chronological order thus displaying the date and time order that the different products were picked.
Ideally this information is to be displayed on the same sheet as the drop down list.
Can anyone please help with this query?