2nd post... I'm an Excel beginner!
I have a file with four worksheets, expenses by city. I wrote a sumproduct formula in each worksheet to calculate the totals by credit card type, and need to display the totals in the first sheet.
Ideally, I would like to copy the box with the formulas and paste it on the first sheet, calculating the totals from the correct sheet still. My goal is to take the data and past it in, having my formula calculate the totals by card type and display in the first worksheet (I'm a big fan of minimal manual work haha).
Is it possible to define a formula to a worksheet and display in another?
I have a file with four worksheets, expenses by city. I wrote a sumproduct formula in each worksheet to calculate the totals by credit card type, and need to display the totals in the first sheet.
Ideally, I would like to copy the box with the formulas and paste it on the first sheet, calculating the totals from the correct sheet still. My goal is to take the data and past it in, having my formula calculate the totals by card type and display in the first worksheet (I'm a big fan of minimal manual work haha).
Is it possible to define a formula to a worksheet and display in another?