PLEASE HELP

I have the following table in Excel.

code Name qty price value remarks

1 XX 2 2 4
1 YY 3 2 6
2 ZZ 1 2 2

The above is a sample. I have a table with over 200 records. I want t
move, say all records with the code 1 to a new sheet, code 2 to anothe
and so on. Is this possible with VBA.

Thank

--
Message posted from http://www.ExcelForum.com