Create a new list from exiting data with variables

[jdhfch]

Hi,

Please can someone help?

I am trying to create a list from a master list based on a criteria. Below is an example

https://www.dropbox.com/s/ui61g35ycc...nshot.jpg?dl=0

Basically, I want to create a list from the master list in row A & B

I want to use the account manager name in cell D3 (John in this instance) and pull all instances of John from row A, then all instances of Johns customers as well in row B. I want there to be no spaces.

Many thanks

Jason

 

[AlanY]

you're welcome
glad that we got it sorted