View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bclancy12
 
Posts: n/a
Default How do I change column references when filling down a formula

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