Send me a sample sheet. Say, the first 10 lines. I will
write the code for you.


I need more info. Do you want the new sheetname to
be "Code 1" etc..
I just need to see where the cell references are. Are
there any blank cells (no data) in the table?

Do you want all data copied or just the data to the right
of the Code value?

If you have 200 codes, you will get 200 sheets plus the
original.


regards
Mark

Visit:
http://au.geocities.com/excelmarksway

-----Original Message-----
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 to
move, say all records with the code 1 to a new sheet,
code 2 to another
and so on. Is this possible with VBA.

Thanks


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

.