Hello,
I do our monthly books with Exell and, at present, do a few things manually that I'm sure could be done automatically. What I need is a total for each heading such as 'food', 'misc' etc. I want to find those words in one column and then add the values in another that the words relate to. Each total should appear in one cell so I know the monthly expenditure. So lookup all 'foods' and add the sums the word refers to.
Does that make sense? I don't want to change the layout as I've got used to it. Hopefully I can load a pic of how I've laid it out.
I do our monthly books with Exell and, at present, do a few things manually that I'm sure could be done automatically. What I need is a total for each heading such as 'food', 'misc' etc. I want to find those words in one column and then add the values in another that the words relate to. Each total should appear in one cell so I know the monthly expenditure. So lookup all 'foods' and add the sums the word refers to.
Does that make sense? I don't want to change the layout as I've got used to it. Hopefully I can load a pic of how I've laid it out.