Each day I work with a file containing sales data (the number of rows varies by day). Column A has sales info, Column B contains a formula I need to use. I double click the fill handle to copy down the formula. That's easy enough but is there a way to code this to take into account a varying number of rows?