Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help Needed :(
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro help needed :( | Excel Worksheet Functions | |||
Macro needed | New Users to Excel | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |