View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jgmiddel[_9_] jgmiddel[_9_] is offline
external usenet poster
 
Posts: 10
Default 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?