Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find, Loop, Subtotal
I have to use VBA. The only problem with doing it the way you suggeste is that the cell it is looking for contains both numbers and text so can't use = to capture cells. Also, I wont know an acutal locating o where the sum formula will be placed because it is going to find specific entry, insert a row, then place the sum formulas for eac column in the appropriate place. Any more advice? Thanks so much, Adriann -- Adresmit ----------------------------------------------------------------------- Adresmith's Profile: http://www.excelforum.com/member.php...nfo&userid=913 View this thread: http://www.excelforum.com/showthread.php?threadid=27373 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find, Loop, Subtotal
I have to use VBA. The only problem with doing it the way you suggested
is that the cell it is looking for contains both numbers and text so I can't use = to capture cells. NOW you say the data in the cells down't look like what you showed in your example. Grrrrr.... It always helps to post your REAL data, so the appropriate solution can be given. Doing otherwise wastes time on both ends. SUMIF can use wildcards when searching for text entries, i.e. =SUMIF($A$1:$A$100,"*5200*",$C$1:$C$100) Also, I wont know an acutal locating of where the sum formula will be placed because it is going to find a specific entry, insert a row, then place the sum formulas for each column in the appropriate place. Then that's another task your macro has to do: define the upper and lower rows to be SUMMED for each column, and generate the appropriate formula using those row numbers. That will be a lot faster than identifying the rows, then using For/Next loop to test each cell, i.e. the "brute force" method. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
subtotal loop | Excel Discussion (Misc queries) | |||
Find & loop in VBA | Excel Discussion (Misc queries) | |||
Find, Loop, Subtotal | Excel Programming | |||
Find loop | Excel Programming |