Hi all,
I have a sheet that contains the master data (Sheet called "Workplan"). I have also created a sheet called "Job Analysis".
In the Job Analysis sheet I have created a drop down list and what I am hoping is to get code that will copy rows of data based on the condition/selection of the drop down list.
The criteria listed in the drop down list are: "Completed", "In-Progress", "On-Hold".
Therefore, as an example: if I select "Completed" from the drop down I want all the rows that have a job status listed as: "Completed" in the Workplan sheet to populate in the Job Analysis sheet
Workplan Sheet:
Job Analysis Sheet:
The work Plan sheet acts as the master and new rows of data will be added so I am hoping the code will allow for new data to filter through based on the condition in the drop down selection.
Sorry if I am unclear. Also I am not using Microsoft 365 or Excel 2021 so cannot use the new "Filter" function which would be perfect for this scenario.
I have a sheet that contains the master data (Sheet called "Workplan"). I have also created a sheet called "Job Analysis".
In the Job Analysis sheet I have created a drop down list and what I am hoping is to get code that will copy rows of data based on the condition/selection of the drop down list.
The criteria listed in the drop down list are: "Completed", "In-Progress", "On-Hold".
Therefore, as an example: if I select "Completed" from the drop down I want all the rows that have a job status listed as: "Completed" in the Workplan sheet to populate in the Job Analysis sheet
Workplan Sheet:
Job Analysis Sheet:
The work Plan sheet acts as the master and new rows of data will be added so I am hoping the code will allow for new data to filter through based on the condition in the drop down selection.
Sorry if I am unclear. Also I am not using Microsoft 365 or Excel 2021 so cannot use the new "Filter" function which would be perfect for this scenario.