Need more details
Does sheet 1 have other data from previous posts or updating?
Are you copying the entire row/rows or a definete range?
When you have copied your row/rows or range from sheet one, I assume that you then activate sheet 2. Yes/No.
On Sheet 2, where do you paste this updated data?
Do you always paste after the previously last pasted updates?
Are you always pasting into column a ?
After pasting into sheet 2, what data do you want printed.
After printing, do you want the file saved?
What sheet do you want displayed when you save?
I think that this is all the info that is needed.
Bookmarks