Hi:
I have a range of data on a single worksheet:
1 name1 address1
1 name2 address2
2 name3 address3
3 name4 address4
3 name5 address5
3 name6 address6

I have to copy all rows with 1 in column A to a separate worksheet called 1,
and the same for "2" and "3". I'm a bit iffy on how to use the VLOOKUP (is
it relevant here?). I have 1500 lines of data so am looking to automate.

thanks for your help.