IMPOSSIBLE MACRO TO WRITE..............Or so it seems! :-)

[sssb2000]

Hi everyone,
I'm writing a very large code and this is one of the last parts i can't figure out to complete the entire thing
I was wondering if anyone could help me write a code for the following problem:

code would

-Check with cell "G39" to see if the value is greater than 0, if so:
-search Column AA
-Find the lowest set of numbers (in the example above, it would be 4)
-Add 1 to the rows corresponding to that number.But add the 1 in column Z
-Subtract 1 from G39 (so in this case, Z964:Z968 would all get a 1 BUT G39 would only lose 1 NOT 5)
-check to see if G39 is greater than 0...If so:
-search AA again, find the lowest number (code MUST NOT add to a number more than once....so in the second search, it would choose 9)
-add 1 to the corresponding rows..but in Column Z
-subtract 1 from G39

-Do this until G39 is zero

Please help ray:

non-Working v7 1-31-05.xls
	Z	AA	AB	AC
964		4
965		4
966		4
967		4
968		4
969
970		9
971		9
972		9
973
974		29
975		29
976		29
977		29
978		29
979		29
980
981		56
982		56
983		56
984		56
985		56
986		56
Sheet1

 

[Von Pookie]

Please continue in your original thread:
hhttp://www.mrexcel.com/board2/viewtopic.php?t=127800