Hi Excel Geniuses,
I am creating a checkbook with dropdown a drop down menu for different GL Codes. I would like a summary of each GL Code on a single page. I figured out my formula, but I'm having trouble sequencing the formula to reference the same cells on each page and hope to not have to copy and paste each cell then manually change the page number or column number. Here is an example of what I'm trying to accomplish.
Any shortcut to help me not have to copy and paste then edit each formula would be greatly appreciated.
Thank you in advance.
I am creating a checkbook with dropdown a drop down menu for different GL Codes. I would like a summary of each GL Code on a single page. I figured out my formula, but I'm having trouble sequencing the formula to reference the same cells on each page and hope to not have to copy and paste each cell then manually change the page number or column number. Here is an example of what I'm trying to accomplish.
=SUMIF('01'!F5:F54,Daily_Detail!V2,'01'!E5:E54) | =SUMIF('01'!F5:F54,Daily_Detail!W2,'01'!E5:E54) | =SUMIF('01'!F5:F54,Daily_Detail!X2,'01'!E5:E54) |
=SUMIF('02'!F5:F54,Daily_Detail!V2,'01'!E5:E54) | =SUMIF('02'!F5:F54,Daily_Detail!W2,'01'!E5:E54) | =SUMIF('02'!F5:F54,Daily_Detail!X2,'01'!E5:E54) |
=SUMIF('03'!F5:F54,Daily_Detail!V2,'01'!E5:E54) | =SUMIF('03'!F5:F54,Daily_Detail!W2,'01'!E5:E54) | =SUMIF('03'!F5:F54,Daily_Detail!X2,'01'!E5:E54) |
=SUMIF('04'!F5:F54,Daily_Detail!V2,'01'!E5:E54) | =SUMIF('04'!F5:F54,Daily_Detail!W2,'01'!E5:E54) | =SUMIF('04'!F5:F54,Daily_Detail!X2,'01'!E5:E54) |
Any shortcut to help me not have to copy and paste then edit each formula would be greatly appreciated.
Thank you in advance.