Convert select columns of text on 2 specific pages of a Google worksheet to uppercase
We have a shared worksheet and I’ve ben using the top section of this code to automatically change text entered by users (in select columns) to uppercase. Historically, I’ve only had to do this on one page on the worksheet. Recently we had to add a second page to the sheet. Very similar funcionality and layout, but it does have to exist on a new tab. I made a stab at duplicating my code to the new sheet, but the code only works on the original page (PDI), not the new one (Premium_PDI). Is there a simple way to get this code to work on both sheets?