lundi 9 mars 2020

Extracting data from one excel sheet to another

I have a large excel file that looks like this: enter image description here

And it then goes on all the way to F01. And then repeats itself again with A01,A02... and so on and on and on.

How can I create a new sheet that extracts all the data from only the wells named A01? I thought about IF statements but do not really have any idea on how to succeed with it.

Aucun commentaire:

Enregistrer un commentaire