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 |
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 |