populating a list from another worksheet with 1 criteria

Posted by Arcadian on Stack Overflow See other posts from Stack Overflow or by Arcadian
Published on 2010-06-08T03:18:07Z Indexed on 2010/06/08 3:22 UTC
Read the original article Hit count: 383

Hello, here is my dilemma. I have two worksheets one that has the name of clients and one that i want to copy the names to depending on the city. For instance: associated to each column is last name, first name and city. i have hundreds of names associated to different cities and what i would like is from worksheet1.xls to copy all the New York clients to worksheet2.xls either when i open worksheet2 or via macro what ever is easier and because last name is in one cell and the first name is in the other i would have to copy both. I saw that its possible to link cells from one worksheet to another and then do a vlookup depending on the criteria. Is that the best easiest way or is there another?

thanks in advance

and cheers

oleg

© Stack Overflow or respective owner

Related posts about excel

Related posts about excel-vba