I am new to the world of writing macros no experience other than recording them. I was given a challenge and not sure even how to start on it.
In Excel 2010 I have one workbook that has multiple worksheets within it. Worksheet one called “Palletizing Downtime” is linked and feeds data from some of our equipment which populates two columns called “Minutes” and “Times down” under each shift per line (example attachment 1). This is a daily feed over and repopulates itself every day per shift.
What they want to happen is to have the data that is populated daily by our equipment on spreadsheet “Palletizing Downtime” pull over and populate into another worksheet at the end of each shift daily at a specific time so that the data is never lost. First shift I need it to move over and save at 4:00 pm daily, 2 shift is 12:00 am daily and 3 shift is 8:00 am daily. This data would be saved to the spreadsheet called “A Line” (example attachment 2). I would appreciate any help anyone could provide. I have some course scheduled in late Sept to help me learn about macros.
Bookmarks