Results 1 to 2 of 2

Thread: cell reference from one sheet to other sheet use variable

  1. #1

    cell reference from one sheet to other sheet use variable



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 informationTest333.xlsm thanks hassan

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •