I have a list of people from different states with names, addresses, etc over
several columns... They're all on the same sheet and the sheet is updated
frequently (people are added).
I then have a tab for each state and would like each tab to update according
to the state found on the main sheet with the info found there (names,
addresses, etc). If I do a lookup function, then I only get one result, but I
have more than 1 person, say from California... I would like to have all the
people from CA show up in the CA tab. No copying and pasting...
Any ideas?