I have a workbook with multiple worksheets (monthly expenses)
I want the first worksheet to be yearly totals. But, I'd like at least part of those totals be from some indivdual things like each utility. So..... Is there a formula that can search all worksheets for a the word Electricity and get the value of the cell adjacent to it?
I tihnk I just need one example and i'll be on my way.
have a look on below
https://exceljet.net/formula/search-multiple-worksheets-for-value