On Excel, how do you compile a summary of all of the worksheets without adding everything up / just counting how many of each category there is?
So for example, if it was set up as a shopping list, with a different sheet for each shop, and each shop with the items you're going to buy, etc., how do you make an overview of every row of text from each into one main sheet?
Does that even make sense?!
I've tried the consolidate thing, & the pivot table wizard, but nothing does quite what I want it to, the way I'm trying it anyway!
Please or to access all these features
Please
or
to access all these features
Geeky stuff
Consolidating in Excel
5 replies
PrickleHead · 30/01/2014 09:58
OP posts:
Please create an account
To comment on this thread you need to create a Mumsnet account.