Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CUT And PASTE
I have an excel sheet that contains 3 columns
One of the columns contains dates I do a sort on the DATES- latest dates first That's where I get stuck I want to select ALL the columns where the date column shows the latest date/then cut and paste the select section to a different worksheet A B C 1 lion black 12/12/2003 2 cow blue 12/12/2003 3 dog red 12/12/2003 4 cat yellow 12/12/2003 5 lion red 10/12/2003 6 cat green 8/8/2003 7 snake blue 6/6/2003 In the example above I would want to capture a1 to c4 Thanks Norton Virus checker 2003 says this email is clean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CUT And PASTE
try datafilterautofilter
-- Don Guillett SalesAid Software Granite Shoals, TX "pcor" wrote in message ble.rogers.com... I have an excel sheet that contains 3 columns One of the columns contains dates I do a sort on the DATES- latest dates first That's where I get stuck I want to select ALL the columns where the date column shows the latest date/then cut and paste the select section to a different worksheet A B C 1 lion black 12/12/2003 2 cow blue 12/12/2003 3 dog red 12/12/2003 4 cat yellow 12/12/2003 5 lion red 10/12/2003 6 cat green 8/8/2003 7 snake blue 6/6/2003 In the example above I would want to capture a1 to c4 Thanks Norton Virus checker 2003 says this email is clean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
can you change the default paste method? (paste values) | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) |