Need help archiving data

[sbates07]

Hi Guys,

So I work for a company and I want to make a spreadsheet that we can enter our daily production for multiple crews on the first page including the job#, location, crew, job type, and quantity for each day of the week. Then I want to make all that data automatically archive into another spreadsheet which will track all of my work for the year. Is this possible and if so could you steer me in the right direction. I want to make this dummy proof for the office personnel.

Thanks

[alansidman]

Welcome. We look forward to your participation.