how to get cell value change automatically from range and print the sheet

Copper Contributor

I have 20 number on Sheet 2 Range A1:A20

And My Sheet 1 has some sort of certificate i need to change the value automatically which is defined in sheet2 Range A1:A20 and send print of sheet 1 automatically 

1 Reply


Which cell on Sheet 1 has to be set to the value of A1, A2, ..., A20 on Sheet 2?