I have been trying to resolve this by researching on Google, and on here but I cant seem to find the specifics I require....I have 2 worksheets, one called Last week and 1 called current week.
I have applied autofilters to 2 of the columns on current week sheet:-
Range("A1:X1").Autofilter...