Excel - Repeat filter for all worksheets with name contains QTR

Scripting Forums AppleScript | Mac OS X
,
#1

I have a basic filter setup and it is working properly. I would like to run filter script on every worksheet in workbook that contains “QTR” in the sheet name. Tried a repeat loop but having problems trying to activate the worksheet to apply filter

tell application "Microsoft Excel"
   repeat with ws in (get name of (every worksheet in active workbook whose its name contains ("QTR")))
                   
            tell range "A1" of active sheet
               
                autofilter range
               
                autofilter range field 6 criteria1 ¬
                   "<>NTB" with visible drop down
           end tell
   end repeat
   
end tell

Thanks

#2

There is no need to select.
By the way, the field 6 of the filter is showing those rows whose column F entry is not “NTB”.

tell application "Microsoft Excel"
	repeat with oneSheet in (sheets in workbook "Workbook1.xls") as list
		if get name of oneSheet contains "QTR" then
			try
				autofilter range (range ("A1") of oneSheet) field 6 criteria1 "<>NTB" with visible drop down
			end try
		end if
	end repeat
end tell
#3

Works like a champ. Thanks!