Thanks, Don. Let me see what progresses, but I think drhalter has me
covered on this one.

D

"Don Guillett" wrote in message
...

Send me a private email if you like
--
Don Guillett
SalesAid Software

"Dean" wrote in message
...
Much appreciated but, if I have to do that, it seems like I'm asking for
too much. I will e-mail you about what you might charge. I would need
to clean out some stuff because it is proprietary and I would get in
trouble otherwise and I'm off on another job for about 10 days, so it
won't be before then probably.

Actually, I have hired one of you guys for one job but he took new
employment just after and is just too swamped the last two times I've
asked him for more help. I won't mention his name because he may not
want me to, but if he reads this and wants to tell anyone I'm safe, I
hope he will!

Thanks again
Dean

"Don Guillett" wrote in message
...
If you like you can send me a workbook with exact details of what you
want and copies of these messages.

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...

BTW to have it fire each time someone makes a change, put into a
worksheet_change event within the worksheet module.
--
Don Guillett
SalesAid Software

"Dean" wrote in message
...
I was wondering if anyone could help me with creating a macro procedure
to do the following, which is a pain to do manually, and needs to be
redone every time anyone changes anything in my spreadsheet, which if
often! I think I've learned enough so that I can troubleshoot the
code, should there be any problem, if someone can supply it to me. By
the way, the columns are really, AU, BH, and AV but I thought it would
be easier to ask for A, C, and B below, and edit that myself. Please
let me know if I have left anything out.



From rows 82 to 164, inclusive, I want to check Column A, one row at a
time (each row is one month later). If the entry is <= 10,000, then
there is nothing needed, so I want the cursor to simply move down to
the next entry in that column. If, in the Jth row, the entry is
10,000, then it needs to do a test. It needs to look forward to the
next row in this same column A where there is another entry greater
than 10,000 - let's call it the Kth row (K <= 165, at some point,
there will be no such 'future' value greater than 10,000, so then set
K = 165). If the sum of entries in another column, column C, from
row 82 until (and including) this 'future' row K is zero, then, once
again, no action is required and we should just move down one row (to
J+1) in column A.



However, if the above test fails to produce zero, then I want to slide
the cursor sideways over to the Jth row of column B and enter the
value 10, then repeatedly increment by 10 more, until the second
condition above is met. Occasionally, before this condition is met,
another increment of 10 causes the entry in row J of column C to
exceed 999,999. If so, then I want to back off to the prior increment
of 10 and end the procedure for the Jth row.



Then, go back to column A and continue with the J+1st row, ending at
row 164.



Thanks so much!

Dean