Posts by acct1958

    Re: VBA Code for renaming worksheets

    Thank you for your reply. So column E will either be an M or B meaning Make or Buy. I would like each part number from column b that we make in column E to be made into a new sheet with the part number as the name of the existing next sheet. I think I understand what you are saying and will give this a try. Thank you again

    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.

    Thank you