JorgeFlores
10-25-2017, 03:30 AM
Hello Experts!
I have the following Problem that I would like to solve. I have already searched through current threads and have not find a solution and my Knowledge is not enough to even define how I could start.
I have a sheet (attached to this threat) with Solar Panel names and Date with times and I would like to do the following: to search for all values that are less than 2,5 (or less than any other value set as reference to compare) and in a new sheet paste the Name of the Solar Panel and at what times it had this value less than 2,5. This is thought to be done once a month and for more than 1,000 Panels so we can reclaim Warranty to the Panel manufacturer and/or sent technicians to check if Panels are correctly wired. Could someone help me with a VBA Code that could do such?
Thank you very much in advance, having this would done would mean a lot to me and to my chances of staying at the Company, since now I am just a working Student.
Jorge
I have the following Problem that I would like to solve. I have already searched through current threads and have not find a solution and my Knowledge is not enough to even define how I could start.
I have a sheet (attached to this threat) with Solar Panel names and Date with times and I would like to do the following: to search for all values that are less than 2,5 (or less than any other value set as reference to compare) and in a new sheet paste the Name of the Solar Panel and at what times it had this value less than 2,5. This is thought to be done once a month and for more than 1,000 Panels so we can reclaim Warranty to the Panel manufacturer and/or sent technicians to check if Panels are correctly wired. Could someone help me with a VBA Code that could do such?
Thank you very much in advance, having this would done would mean a lot to me and to my chances of staying at the Company, since now I am just a working Student.
Jorge