Copy cells with unspecified values to new sheet
 

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

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/

Copy cells with unspecified values to new sheet
 

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/

.

Copy cells with unspecified values to new sheet
 

Many thanks - works great - except it says you can only filter to the
active worksheet - buts thats no problem I can easily cut & paste to
where I actually want it.

Great site - great help - "I'll be back"!!
John


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