Filter results based on cell value and print results

Hi All, I am having trouble getting this to work. I have an spreadsheet with data from columns A5 to P5 with continually growing rows. Row 4 is the header row. I would like to be able to enter a value into cell E2 and have the results filtered based on that input. I would like the filter to produce results if Column B contains the data entered in E2. After various searches I found this code that applied to my situation but I cannot get it to work. Thank you in advance for any help.

Please Login or Register  to view this content.

Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

Attach an EXCEL sample to be sure macros are running with real data

See next code

Please Login or Register  to view this content.

In addition see file attach and the validation list for cell E2

What is the issue with the last file sent ?
There is a validation list for E2 and the macro is fired when the value is entered ...no ?

and when entering "12345"
you want to display all Cable# starting by "12345" !!

See next code

Please Login or Register  to view this content.

Yes this is because there is a validation list which must not exist anymore if you want to enter partial part of the input
See file file attached
Else select E2, then Data > Data Validation > Allow > Any value

Yes I apologize, wrong file

Good, we got it.
Have a look to closed the thread