ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sorting, replacing data (https://www.excelbanter.com/excel-programming/417989-sorting-replacing-data.html)

jgmiddel[_9_]

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?

jgmiddel[_9_]

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