I have several worksheets in a workbook but need to autofilter unique values from worksheet datacompile to report worksheet in same workbook


The headers from datacompile sheet that need to be auto filtered unique are f1 to h1 still last data row ,to sheet report range a1 to c1 which are headers