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