I need to write a macro (or ? VBA) to look at a column of numbers an
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 O
with simple macros!
Thanks
Joh

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