Excel Macro for Search Box

[NBC_Blamo]

Hello, I am looking to create a Macro Button that would allow searching of pivot table that would search based on Column A and display results based on the entire row with the correct results. i realise this function is in the ctl+f but it has to much data. I do not need to see the cells that contain the data just the data itself. I have tried to use some of the macros that i have recently found through other threads but they are not quite what i was looking for. If anyone can assist, that would be great! Thank you in advance!