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
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