V
vidguru
I am looking for help to create a macro to do the below. I have an
idea how to do it with an if then statement, but that would require
dragging the formula all the way down, and the data can very from 500
rows, to a few thousand. (Can't autofill based off of column D since
there are blank lines).
Column D contains ID numbers. We have the
page subtotaled counting the ID numbers so it says ..... count.
Column S are payments. Obviously when it is subtotaled, it adds a
line, and lists ....count.
I would like a macro to go through column
D and for cells that contain the word count, for it to enter the word
overpayment in column S (same row) and sum (or subtotal) all of the id
numbers values in column t ( I mean the values above it. for example,
it would sum all in cloumn t for the id number ab3s0). I know I could
do that using sumif
command outside of a macro, but like I said, it can contain thousands
of rows. I thought about non macro ways of doing it, If then
statements about putting the word overpayment in column S, but
everything i did would wipe out the values in the rows that don't
contain the word count. Also,again, could be thousands of rows,
would suck to manually look for them all
Column D Column S column t
ab3s0 17.99 5.18
ab3s0 17.99 3.27
ab3s0 count overpayment Sum of the above
abs1 15.87 5.38
abs1 23.85 5.20
abs1 5.24 1.07
abs1 count overpayment Sum of the above.
idea how to do it with an if then statement, but that would require
dragging the formula all the way down, and the data can very from 500
rows, to a few thousand. (Can't autofill based off of column D since
there are blank lines).
Column D contains ID numbers. We have the
page subtotaled counting the ID numbers so it says ..... count.
Column S are payments. Obviously when it is subtotaled, it adds a
line, and lists ....count.
I would like a macro to go through column
D and for cells that contain the word count, for it to enter the word
overpayment in column S (same row) and sum (or subtotal) all of the id
numbers values in column t ( I mean the values above it. for example,
it would sum all in cloumn t for the id number ab3s0). I know I could
do that using sumif
command outside of a macro, but like I said, it can contain thousands
of rows. I thought about non macro ways of doing it, If then
statements about putting the word overpayment in column S, but
everything i did would wipe out the values in the rows that don't
contain the word count. Also,again, could be thousands of rows,
would suck to manually look for them all
Column D Column S column t
ab3s0 17.99 5.18
ab3s0 17.99 3.27
ab3s0 count overpayment Sum of the above
abs1 15.87 5.38
abs1 23.85 5.20
abs1 5.24 1.07
abs1 count overpayment Sum of the above.