Looking to use a Range from sheet "Employee List" ("A2:A33") and name only sheets with the beginning codename "FTE*".
<tbody>
</tbody>
I know I need to use "For Each in range" and "if FTESheet.Codename like "FTE*" Then". But not sure how to loop through the Range and the Sheets at the same time.
Codename | Cell | Range | Result |
FTE01 (FTE01) | A2 | Todd | FTE01 (Todd) |
FTE02 (FTE02) | A3 | Steve | FTE02 (Steve) |
Table (Table) | Not Renamed | ||
FTE03 (FTE03) | A4 | Mark | FTE03 (Mark) |
Report (Report) | Not Renamed |
<tbody>
</tbody>
I know I need to use "For Each in range" and "if FTESheet.Codename like "FTE*" Then". But not sure how to loop through the Range and the Sheets at the same time.