I have a named range "Title" on my "Settings" worksheet.
In two separate worksheets ("Direct" & "Partner"), I want to be able to auto-populate a group of cells on workbook open.
Essentially, if Title="Quote", I want the group of cells to be blank so that the user can enter whatever text they want.
If it is NOT "Quote", I have specific text (located in my "Data" worksheet) I need hard coded into the cells on workbook open or delete, etc.
Any help is much appreciated.
Bookmarks