Hello,
To explain my situation, I work for an automotive supplier and deal directly with the production machinery in our facility. This machinery is fully automated. Every 8 hours the HMI (Human Machine Interface)generates a log file of alarms and events that occur during the machines operation. This log file then gets pasted into Excel. The log contains text commentsmessages in column A. I have created a Excel Workbook that counts the number of instances the message occurs and displays them in a 'daily worksheet', {=COUNTIF('Shift 1 - 22 to 6'!A:A,A2)} comparing it to a master message list containing all of the alarm/event messages in that can occur (2250 total). The log is always in a different order in its column than the master message list. At the end of a 24 hr period the totals are summed sorted and filtered in the 'daily worksheet' and a daily report is generated as to how many times a particular alarm/event occurred and which shifts they occurred on. Then the data is cleared and the next day begins. My problem is I want to have a button with a assigned macro for each day of the week to match the text in the 'weekly total' master list, then copy the 5th cell to the right into a 'weekly total' worksheet in the same workbook, and be able to retain that data in the weekly report. I've tried some index/match functions but cannot get them to work. Any advice on how to do this is greatly appreciated.
Windows NT4.0 SP6
MSExcel 97
To explain my situation, I work for an automotive supplier and deal directly with the production machinery in our facility. This machinery is fully automated. Every 8 hours the HMI (Human Machine Interface)generates a log file of alarms and events that occur during the machines operation. This log file then gets pasted into Excel. The log contains text commentsmessages in column A. I have created a Excel Workbook that counts the number of instances the message occurs and displays them in a 'daily worksheet', {=COUNTIF('Shift 1 - 22 to 6'!A:A,A2)} comparing it to a master message list containing all of the alarm/event messages in that can occur (2250 total). The log is always in a different order in its column than the master message list. At the end of a 24 hr period the totals are summed sorted and filtered in the 'daily worksheet' and a daily report is generated as to how many times a particular alarm/event occurred and which shifts they occurred on. Then the data is cleared and the next day begins. My problem is I want to have a button with a assigned macro for each day of the week to match the text in the 'weekly total' master list, then copy the 5th cell to the right into a 'weekly total' worksheet in the same workbook, and be able to retain that data in the weekly report. I've tried some index/match functions but cannot get them to work. Any advice on how to do this is greatly appreciated.
Windows NT4.0 SP6
MSExcel 97