Hi all
PLEASE PLEASE if anyone can help!
I am in charge of controlling all company assets leaving from and returning to the DC. There is no system in place currently, so I am using Excel 2013 to capture these movements manually.
I have created a dropdown list on my sheet1 (May), to select whichever store the assets went to and returned from. This then updates my second sheet (Summary) by using the formula:
=SUMIF(MAY!A4:A104,SUMMARY!B3,MAY!C4:C104)
This formula works perfectly as it totals up only the selected stores needed.
However, my problem comes in as I have to duplicate sheet1 (May) 30 times to complete a month. By doing this, the formulas do not recognize the other sheets.
Is there any way for me to edit this formula for it to sum all the sheets at the end? Or maybe another simpler way of doing it.
Thanks,,,, Lee
PLEASE PLEASE if anyone can help!
I am in charge of controlling all company assets leaving from and returning to the DC. There is no system in place currently, so I am using Excel 2013 to capture these movements manually.
I have created a dropdown list on my sheet1 (May), to select whichever store the assets went to and returned from. This then updates my second sheet (Summary) by using the formula:
=SUMIF(MAY!A4:A104,SUMMARY!B3,MAY!C4:C104)
This formula works perfectly as it totals up only the selected stores needed.
However, my problem comes in as I have to duplicate sheet1 (May) 30 times to complete a month. By doing this, the formulas do not recognize the other sheets.
Is there any way for me to edit this formula for it to sum all the sheets at the end? Or maybe another simpler way of doing it.
Thanks,,,, Lee