Is it possible to use find all and replace all for unlocked cell in a sheet without changing locked cell. Let’s say in the sheet (TC certificate) there is school phone no 0123456789 and school reg no 12/45 in the upper portion. In the TC sheet there are some formulas like =+’admregister’!G12 (reference to another sheet named admregister) and so on. now I want to replace G12 to G124 for the automatic replacement of student name, gather’s name, addrress, admission no..so on by find 12 and replace with 74 then phone nos and school reg. no also changed to 07434567890 and 74/45. So again I have to change phone nos and reg no manually otherwise I have to find one replace with othes for sevaral times for every formulas. then I can print the TC certificate correctly.
Please help me in this regard.
