Hi,

I'm printing pallet tags for products in a warehouse. I print up t
200 a day.

I have two worksheets , Sheet1 is the working copy that is change
often and then printed, Sheet2 will be a ledger that records that info
each time I print the info in Sheet 1.

If possible, I would like to use a macro to record the data from Shee
1 and place it in Sheet 2...After each print.

Can this be done?

Trav

--
Message posted from http://www.ExcelForum.com