pull data based on dropdown list
Hey guys, 1 worksheet, 2 different tabs. On tab 1, I have a drop down status list for different projects (along with other project information in the row). When a specific status from the drop down list is chosen, I want that project (row of data) to populate automatically in a row in tab 2. I am struggling to populate only the list of a specific status in tab 2, and populate the rest of the line.
