Sorting, replacing data

J

jgmiddel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete row if certain column of that row doesn't contain value 3
formula filling a row from another sheet 2
A Macro to replace a string in a cell with a string from another cell??? 2
Looping and Offset 2
a loop formula that filters and prints? 2
Macro Help 5
Hidind rows conditionally 3
Delete Rows from multiple Sheets. 3

Top