Removing Duplicates from multiple worksheets

J

J.S. Will

Hi I need to remove duplicates from multiple wotrksheets and then give me the
results in one final worksheet.
 
M

Max

Stack it up manually into a single sheet (a one-time copy/paste effort,
doable in 1/2 min). Then create a pivot on the stacked data, place the col
header into both ROW and DATA areas (set to Count in DATA), finish up the
wizard. voila, you're done in another 10 seconds. Any joy? hit the YES below
 
Top