Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting, replacing data
What I need is a macro the following steps:
Overview is in Sheet1 1) Macro searches for the lowest value in column K 2) The macro must replace the entire row (where that lowest value is in) to Sheet2 3) Macro must check the value (XX) in column A of the replaced row in Sheet2 4) Checks in column A of Sheet1 for XX 5) Replaces all rows with value XX from Sheet1 to Sheet2 6) After all rows with XX are replaced: sorts the replaced rows to column B 6) Adds an empty row 7) Repeats action untill sheet1 is empty (next lowest, next xx, etc) Anyone who can help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting, replacing data
About 6: sorting of the "group" NOT the whole sheet!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Imported Data Not Replacing Existing Data - Excel 2007 | Excel Discussion (Misc queries) | |||
Sorting Data into columns without replacing the columns with data | New Users to Excel | |||
Replacing data in a row of sheet1 with data in a row of sheet 2 based on a field in both sheets being the same? | Excel Programming | |||
Repost:replacing data on a non focused worksheet with calculated data from the same sheet | Excel Programming | |||
replacing data on a non focused worksheet with calculated data from the same sheet | Excel Programming |