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.