Thread: Copy cells with unspecified values to new sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JWolf JWolf is offline
external usenet poster
  
Posts: 136
Default Copy cells with unspecified values to new sheet
No macro needed.
DataFilterAdvancedFilter
Check copy to another location, check unique records only, specify the
copy to range, click OK.
JRM < wrote:
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/

Reply With QuoteReply With Quote