Hi
one way:
- select your source data
- goto 'Data - Filter - Adavnced Filter'
- choose a seperate range as target and check 'unique
values'

-----Original Message-----
I need to write a macro (or ? VBA) to look at a column
of numbers and
copy each different number to another sheet.
eg. Sheet1 Col A : contains
12345
12345
12345
67890
67890
88741
88741
88741

I need to copy 12345 to Sheet2 A:1
then find the next number eg. 67890 & copy to A:2
then 88741 to A:3
etc. etc down sheet1 until a blank cell is found.

Any help gratefully received as I'm very new to VBA's but
reasonably OK
with simple macros!
Thanks
John


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

.