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

Need Help with a VBA subroutine 0
Match and Extract Data 1
Can I send an email too? 3
Arrays and scattered cell values or another way? 16
fill in data that is not empty 1
Need help to fix vlookup function in macro 1
Conditional Formating: MAX & MIN 3
Copy data into sheets 13

Top