Getting any formula to stop at the next blank space
 

I frequently write VLOOKUP and SUMIF formulas for my spreadsheets and
have found myself typing the same thing over and over. How can I add
in a command that makes each formula stop at the next blank. I also
have to make the formula references "absolutes". What I'm wanting to
do is copy and paste the same formula down without sacrifices the
absolute references.


--
ajpowers
------------------------------------------------------------------------
ajpowers's Profile: http://www.excelforum.com/member.php...fo&userid=9406
View this thread: http://www.excelforum.com/showthread...hreadid=377875