I have been asked to modify an existing excel.macro that someone else wrote. The data is a list of devices, their down time and other data. There is a blank summary shhet with a button to invoke the macro. The macro asks for user input of a bench mark time in hours via msgbox, and then it sums up all the downtime for each device and if the total down time is over the bench mark, the device and it's total is on the summary sheet, with the individual down times for each device. What I have been asked to do with the macro is to copy the entire row for each individual down time on the summary sheet.I can't figure it out.
I attach the spreadsheet
Bookmarks