I've been trying to find a solution online without success. It seems a fairly simple thing that I want to do but finding a way to write a formula that will automatically do it, is another matter.
In the spreadsheet above, what I want to do is create a formula that will search the data set with the yellow header (i.e., A1:D19) for a specific value/criteria in column D (e.g., I defined the value/criteria as "1" in cell B21) and then copy the rows that contain that value/criteria into a new sheet. For example, the orange data sets represent the new sheet (I would a sheet for each different value in Column D, so for this data set it would need 4 new sheets). In the example, I set the criteria to "1" so Sheet 1 has all the rows that have "1" in Row D of the master sheet.
At the moment, I just do this manually by filtering the values in Column D and then copy/pasting to a new sheet. If possible, I would like to have a formula I could put in the target cell of each new sheet that would automatically extract the date from a master sheet. I want to make it as simple as possible for the end users. I literally just want them to paste a data set into the master sheet and let the formulas in the other sheets automatically extract the rows.
I hope I explained myself clearly. I would be ever so grateful for your help. Thank you in advance.
In the spreadsheet above, what I want to do is create a formula that will search the data set with the yellow header (i.e., A1:D19) for a specific value/criteria in column D (e.g., I defined the value/criteria as "1" in cell B21) and then copy the rows that contain that value/criteria into a new sheet. For example, the orange data sets represent the new sheet (I would a sheet for each different value in Column D, so for this data set it would need 4 new sheets). In the example, I set the criteria to "1" so Sheet 1 has all the rows that have "1" in Row D of the master sheet.
At the moment, I just do this manually by filtering the values in Column D and then copy/pasting to a new sheet. If possible, I would like to have a formula I could put in the target cell of each new sheet that would automatically extract the date from a master sheet. I want to make it as simple as possible for the end users. I literally just want them to paste a data set into the master sheet and let the formulas in the other sheets automatically extract the rows.
I hope I explained myself clearly. I would be ever so grateful for your help. Thank you in advance.