Hi Bclancy,

one way is create a list with 1,2,3...12 in one column suppose it starts on
g1 thu G12 so

the formula could be:
=indirect(address(2,col()+g1,1,1,"Total Commissions")
and copu it down

hope this helps
Regards from Brazil
Marcelo

"bclancy12" escreveu:

I want to drag this formula down 12 cells (months)

='Total Commissions'!B$2
='Total Commissions'!C$2

I know that the "$" will make the Row Reference static, but how do I get the
Column Reference to change