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? |
Sorting, replacing data
About 6: sorting of the "group" NOT the whole sheet!
|
All times are GMT +1. The time now is 08:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com