cell reference from one sheet to other sheet use variable

hassan1960

New member
Joined
Feb 1, 2013
Messages
17
Reaction score
0
Points
0
i try to use cell reference from one monthly payable sheet to balance sheet.
if i have one payable sheet this formula works, and any time i change the value in payable sheet automatically change the value in balance sheet no problem


ActiveCell.Formula = "=SUMIF(_2013_02[Status],'2013_02'!J$6,_2013_02[Amount])"

but because the monthly page which every month the page create automatically i have to use variable for (Page name) which i have problem, Xname is Variable as string

ActiveCell.Formula = "=SUMIF(""&Xname&""[Status],'Xname'!J$6,""&Xname&""[Amount])"


(sheet name[column name],'sheet name '!cell location ,Sheet name[column name])

i include the project for informationView attachment Test333.xlsm thanks hassan
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Code:
ActiveCell.Formula = "=SUMIF(" & Xname & "[Status],'" & Xname & "'!J$6," & Xname & "[Amount])"
 
Top