Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort / Copy Macro
I have a spreadsheet in which the data changes daily (As far as number of
rows in each section) Basically the data I want to sort is in columns A through D I need a Macro to sort based on Column C from Largest Number to Smallest Number, and delete any rows in which the number in Column C is less than but not equal to 5. Then copy what is in Column B for each row to another spreadsheet and transpose from the column form to a single row. The catch is the information that needs to be sorted is in the middle of a bunch of other data, so, I would guess I could use some sort of code to match the number "0" in column D for each row to sort and copy... Hope this makes sense, thank you for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort, Copy, and Paste macro, must execute twice to work | Excel Discussion (Misc queries) | |||
Need to sort a row of data and automatically copy in to another ro | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) |