Hello,
I have this kode that works in Sheet1 but i need it to filter from the same inputbox criteria in Sheet2 as well.
My kode is:
Sub Filter_4()
x = InputBox("write the first 4 numbers")
x = Val(x & "000")
y = x + 999
Sheets("Sheet1").Range("$C:$C").AutoFilter Field:=1, Criteria1:=">=" & x...