In Sheet1, cell A1, I enter the codes I am working on. In cell A2, I created a data validation so it is easier for me to select from the list what the status of the code I am working on (i.e. In Progress, Done, Researching, etc.). The data of the data validation for Sheet1 cell A2 is located in Sheet2.
What I wanted is in Sheet3, in column A, I want to list the statuses based on the data validation I created (ie. In Progress, Done, Researching, etc.). I want in Sheet3 column B to automatically populate the code (somewhat like copying the text) that is in Sheet1 cell A1 to the corresponding status I selected in the dropdown list in Sheet1 cell A2.
For example, in Sheet1 cell A1, I entered code 238 and in cell A2 (still in Sheet1), from the dropdown list, I selected the status "Done."
What I want to see in Sheet3 in column B next to the status "Done" (written in column A) is code 238. I want the sheet3 to list all the codes that have their corresponding status in sheet1. It will be a good way for me to quickly glance what codes that is in a particular status so I can tend to them right away.
please help ...![]()
Bookmarks