Hello
I have a worksheet that has a list of people's names in column B of a worksheet called Summary. It starts at B9 and can vary in length. Most names in this list correspond have a worksheet of the same name but some don't.
I would like to be able to loop through each name in the list, find if there is a worksheet with the same name and, if there is, copy and paste the value in A1 of that worksheet into the cell next to the name in column C.
Is this possible?
Thank you
I have a worksheet that has a list of people's names in column B of a worksheet called Summary. It starts at B9 and can vary in length. Most names in this list correspond have a worksheet of the same name but some don't.
I would like to be able to loop through each name in the list, find if there is a worksheet with the same name and, if there is, copy and paste the value in A1 of that worksheet into the cell next to the name in column C.
Is this possible?
Thank you