Dynamic filtering with criteria based on cell value in other sheet - Excel VBA

[CakzPrimz]

Hi,

I have 2 sheets A and B,
Inn sheets A, I have criteria to filter the data on sheets B.
Cell A5 value = "Civil" and I have a button beside the cell to run the macro for filtering data on sheets .
How is the code to filter data based on range value of cell A5 in sheets A, so when I changed the value of A5 into "Piping", then it will filtered the data with "Piping" criteria.

Thanks so much for your help and assistance

Best regards

 

[Takae]

Please modify the red part of your macro.

sheets("B").Range("A1").AutoFilter field:=1, Criteria1:=sheets("A").range("A5").value

 

[CakzPrimz]

Dear Takae,

Thanks for the answer. It works.
Problem solved.

Thank you very much