How to populate sub sheets based on criteria from a master

Closed

EMS360 Posts 2 Registration date Saturday April 15, 2017 Status Member Last seen April 17, 2017 - Updated on Apr 15, 2017 at 09:22 AM

Hello,

I'm working on a master file with sub sheets. I'd like to auto populate data from rows A-S to sub sheets (Dave, Jamal, Addi), based on data entered in row L (Dave, Jamal or Addi).

Is there a way to do this without having to create codes for a macro?

Thanks for any help you can offer.

Michelle Priceman

How to populate sub sheets based on criteria from a master
Typing master pro - Download - Education
Master royale - Download - Strategy
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Macro to copy data from one sheet to another based on criteria ✓ - Excel Forum
How do you auto populate data from multiple sheets to a master? ✓ - Excel Forum

Subscribe To Our Newsletter!