How to make a row auto populate

[MeganLanpolsaen]

Hello,

Thank you in advance for your help!

So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this?

For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate (copy) the rest of the information in that row in the separate sheet?

Thank you!!

 

[Scott Huish]

Perhaps you need VLOOKUP?

https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1