From: J.S. Will J.S. on 5 Feb 2010 11:31
Hi I need to remove duplicates from multiple wotrksheets and then give me the
results in one final worksheet.
From: Max on 5 Feb 2010 12:00
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
"J.S. Will" wrote:
> Hi I need to remove duplicates from multiple worksheets and then give me the
> results in one final worksheet.