Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with offset
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I really need OFFSET? | Charts and Charting in Excel | |||
Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
Offset help | Excel Discussion (Misc queries) | |||
Offset | Excel Programming | |||
Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming |