How to make a row auto populate

MeganLanpolsaen

New Member
Joined
Nov 15, 2019
Messages
3
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!!
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,099,401
Messages
5,468,404
Members
406,584
Latest member
dsberrycpa

This Week's Hot Topics

Top