Combine Cross-Referenced Sheets
Hi - I have 6 Summary sheets that are cross referenced to 6 Regional sheets. These have formulas gathering totals by person. Sort of mimics a pivot table. Works great for stacked bar charts.
I'd like to combine all the totals for each person in one sheet. People might appear on more than one Summary sheet. The names may change (add/delete). The Summary sheets are using a formula to get the distinct names from the Regional sheet.
Unfortunately, a report brings in duplicate names and I'm looking for one row per person with totals from all Summary sheets.
Looking for suggestions on best method to get all the names, no duplicates, and keep them updated.
Help Article Resources
Check out the Formula Handbook template!