I have 12 sheets. Across these 12 I want to search through all sheets for a word in one column (car), take the value from another column (€100) and place the values found in a 13th sheet so I can sum them up.
Try Consolidate
Very few people know about this feature, because it is not used very often. But this function is designed specifically to solve your problem.
aah, thanks jonSUN
Wil certainly give this a go!
Not sure about your question. How is the relation between your several columns? How do you know which “car” column" belongs/refers (?) to a “money” column?
I mean, the 12 worksheets are months, in them I have filled expenses. One column lists the items name and another column lists the cost. So in one cell would be what it is, (in this instance car) and in another cell next to it would be the amount (for example €100) I want to find all cells with the word car, take its value from another cell and place it in a different sheet, the 13th where I can sum up all “car” for the whole year.
I hope this helps
If this is your own seheet, what about trying to make it more simple? What about a single sheet, and filtering the expenses first by year, second by month. And maybe by expense type “car” on demand, or maybe for car in a simple pivot table?
But afaik, maybe I’m wrong, pivoting across many different sheet would hard if not impossible
Thanks, Michaelof, but I can’t. I really want on the 13th sheet a list of expenses summed up. This way I can compare car with boat and aeroplane.