Filtering data to different worksheets

J

japper

Hi all,

I'm sue this should be really simple to do but I'm struggling to get i
to work.

I have a list of account numbers and who has keyed each one on.

I want to filter down the list so that I have a seperate worksheet fo
each person with all of the account numbers (plus other columns of inf
ie. address, phone number) that they have done.

I've tried vlookup but that, obviously, only looks up the 1st accoun
number.

Can anyone point out what I'm missing?

Thank
 
C

ChiragP

I think there are 2 ways to resolve this problem

1. Multiple Vlookups may work across each column i.e

Person Account Name Account Address

So you would have a Vlookup in account name and address.
However, I don't know what format the source document is in

2. Just sort the main list by person and cut and past each person to
different sheets

Hope this helps
 
D

Darlene Kupke

Hi all,

I'm sue this should be really simple to do but I'm struggling to get i to
work.

I have a list of account numbers and who has keyed each one on.

I want to filter down the list so that I have a seperate worksheet fo each
person with all of the account numbers (plus other columns of inf ie.
address, phone number) that they have done.

I've tried vlookup but that, obviously, only looks up the 1st accoun number.

Can anyone point out what I'm missing?

Thank
Click to expand...

Hi,

A few days ago someone on these boards recommended a site named Contextures
that explains filtering. The url is www.contextures.com/xladvfilter01.html.
I went through the exercises and understand filtering much better than I
ever did before. I highly recommend you try this site.

Hope this helps.

Darlene
 
Top