I have data in a table, lets say the table is (A7:M200) and the Headings in this table is (A7:M7).
Column 1 (A8:A200) is the accounts numbers.
I already selected the Row 7 (the headings in this table) then I made Auto filtering.
Now my request is when I write in Cell (E1) any account number to filter that table (A8:M200) according to this selection in E1.
Thank you in advance for any kind assistant.