Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming |