Create PDF with data from specific columns in multiple tabs

[lekh0602]

Hi all,

I am currently working in a spreadsheet with multible tabs, where the format is the same: a table where values (text) from column 5-row 3 (and down), column 6-row 3 (and down) and column 7-row 3 (and down) should be transferred into a PDF with a table consisting of the three columns (they have the same headlines). I would like to activate the macro by inserting a form control button - Sub Button1_Click() - since the users will not all be so tech savvy.

Thanks in advance for any input on this matter.

Regards,
Lee