I'm working with a monthly inventory sheet, and a printout template. I don't fill in all the fields on my inventory every month, and so i drag the fields that have been filled into the print temp.

Is there a way to make the print temp sheet automatically paste cells with information from the inventory sheet, into itself?

Thanks.