Automatically clone entire sheet to duplicate sheet in workbook

[opusarlo]

I need help making Census Sheet automatically clone itself or copy all data to Census Sheet 2 and Census Sheet 3 in real time. This allows me to save to PDF and print 3 different duplex sheets.

[davesexcel]

If you right click on the sheet tab and select move or copy. From there you can copy the sheet and place it where ever you want.

[opusarlo]

i was referring to auto updating as well. I went with the "=" for the cells I wanted to copy...meaning all of them. Then I went into advanced options and turned off "Show zero for cells with no value". Worked like a charm.