Hi everyone, I am relatively new to excel and am basically have been assigned this task where I have to 4K+ different serial numbers, as well as data sheets for these serial numbers. For these serial numbers, I have to go through each and every one of them and copy the range of data that these serial numbers have been provided with into a new excel sheet. I have already manually done 1k+ of these but I am exhausted now. Is there any way to extract this data using a code? I am very new to excel functions/VBA. I'll put in some data below.
and basically i have to extract the VOC ISC and so on onto another sheet where it is just the serial number.
Serial No. | Voc(V) | Isc(A) | Vpm (V) | Ipm(A) | Pmax(W) | FF | Watt marking |
19BM6M7435345 | 49.24 | 10.41 | 40.95 | 9.92 | 406.56 | 79.3 | 405 |
and basically i have to extract the VOC ISC and so on onto another sheet where it is just the serial number.