Hello I'm having some difficult to find the right code for the following goal:

I have a sheet with a macro that when i change a value in the cell E5, automatically fill certain fields in sheet1, searches and return values from a table on other sheet - sheetTable). So after changing cell E5, sheet1 is basically ready to print.

My goal is to select a range of values in a collumn on sheetTable and assign each one of them to Cell E5 on sheet1, and print each one.

So lets say I select 3 cells with values: 45, 50 and 66. When I run the macro it will assign 45 to cell E5 and print sheet1, then it will assign 50 to cell E5 and print sheet1 and finally will assign 66 to cell E5 and print sheet1.

Also, I need to print each ones in PDF and the resulting PDF filename should be the value of E5 cell [basically something like range(e5).value.pdf].

Can anyone help me plz?