I sure could use some help the formula below is on a summary worksheet
and is the formula I for the current month. however, next month i need
the formula to move two columns to the right.

=Mountain!AJ63*1000
next month =Mountain!AL63*1000
=Mountain!AJ71*1000
next month =Mountain!AL71*1000
=Mountain!AJ73*1000
=Mountain!AJ74*1000
=(Mountain!AJ80+Mountain!AJ81)*1000
=(Mountain!AJ87*1000)-YTDLaborBurden-CorpCharge-NonJobLabor

This is what I have so far for code:

Range("C8").Select
Selection.Formula = "=Offset(Mountain!AJ63,0,2)*1000"
Range("C10").Select
Selection.Formula = "=Offset(Mountain!AJ71,0,2)*1000"
Range("C11").Select
Selection.Formula = "=Offset(Mountain!AJ73,0,2)*1000"
Range("C12").Select
Selection.Formula = "=Offset(Mountain!AJ74,0,2)*1000"
Range("C15").Select
Selection.Formula = "=Offset(Mountain!AJ86,0,2)*1000"
Range("C16").Select
Selection.Formula = "=Offset(Mountain!AJ89,0,2)*1000"
Range("C18").Select
Selection.Formula =
"=Offset(Mountain!AJ80,0,2),Offset(Mountain!AJ81,0 ,2)*1000"
Range("C19").Select
Selection.Formula =
"=Offset((Mountain!AJ87,0,2)-YTDLaborBurden-PTDCorpCharge-PTDNonJobExpense))*1000"


--
paully
------------------------------------------------------------------------
paully's Profile: http://www.excelforum.com/member.php...o&userid=37417
View this thread: http://www.excelforum.com/showthread...hreadid=572029