I am looking to copy a formula for a vertical array of data while referencing
the same column. I know that adding two $ before and after a cell letter
references that particular cell each time the formula is copied; however, i
want to reference the same column, not a particular cell. Also, I am working
with over 45,000 data points for 12 different worksheet; how do I copy a
formula down an entire worksheet without having to drag the little black box
at the bottom of a cell?

This will help GREATLY

Thanks!

Scott