Hello, I would like to learn how to rename multiple existing worksheets with the name from a range of cells on the first worksheet based on info from a second range of cells.
For example, I would like to rename multiple existing worksheets with a part number from column B on sheet 1 only if specific information appears in column E of that same line. Can anyone please help?
I have already been able to rename the sheets with the part numbers in column B but I don't want a sheet for every part, just specific ones based on column E.
Any help would be appreciated.