VBA Count Duplicates from a varied range on one sheet using another sheets list

[decadence]

Is it possible to count number of instances of duplicate and unique cells found from a varied range using a list of data from another sheet as a reference to on what to look for? My data will be varied with up to 20,000 rows and up to 10 columns Also the cells will contain both numbers and letters, I will have 2 sheets one with the duplicate data and another with Total Duplicates. Can someone help with this please? Thanks

Example:

From this (Duplicates sheet)

Header 1	Header 2	Header 3	Header 4	Header 5
Apple	Banana	Orange	Pear	Grapes
Orange	Apple	Pear	Apple	Orange
Orange	Pear	Apple	Orange	Pear
Pear	Orange	Pear	Pear	Apple

<tbody>
</tbody>

To This (Total Duplicates Sheet)

Duplicates	Count
Apple	5
Banana	1
Orange	6
Pear	7
Grapes	1

<tbody>
</tbody>

 

[Fluff]

How about
=COUNTIF(Sheet1!$A$2:$E$5,A2)

 

[decadence]

Hi Fluff, thanks for the reply however this formula is for the example, my data is varied so I can't specify exact range

 

[Fluff]

In that case how about
=COUNTIF(Sheet1!A:L,A2)
Change the L to the last column you are likely to get

 

[decadence]

Thanks Fluff, this works perfectly

 

[Fluff]

You're welcome & thanks for the feedback