Dear All,
I have a document with several sheets, actually 50 individual sheets. Sheet 1, Sheet 2 etc.
I need to consolidate data from all of these sheets into one "mater sheet".
For instance, each sheet contains a name of a customer X and a different value Y,Z,V etc. I need to have one master sheet for customer X with a sum of all values for the customer from all of the sheets.
How can I do this easily? The data are not in same rows. SUMIF or SUMIFS? Are these practical to use hen consolidating data from several sheets or are there any other formats I can use?
Pleased to hear an smart suggestions!
Thank you,
Mackan7695
Bookmarks