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