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.
Something going wrong. I’m uploading an attachment. In the TC certificate in formulas (*11) is used but when I want to replace 11 to 6 for another student then if I use replace all then red highlighted phone nos is also changed to 6. If I use replace sevaral times then it is ok.
I’m try to remodel your sheet, just enter Sl. no. in S8 cell to get the desire figure, for printing purpose, please make fill color and text color of the cell S8 white.
Thank you very much Torkona. I just have learned VLOOKUP funda. If I put the highlighted cell outside the printing area then no need of white font and white background.
******Another problem—In my TC certificate I used cell no address of Admregister sheet so in the cell L10, J12, A14 it is automatic gender (Son/daughter, He/She and his/her) but now it is showing wrong in your modified sheet. These are not changed accordingly. Please help me in that regard.
Please edit-
“bears a good moral character. I wish him for every success.”
When you print this type of sheet, some places will be blank and looks odd due to entry of formula in between the lines.
Those 3 cells are in the TC sheet. If I add 3 columns more in the Admregister then it may be bulky enough. Is there any other way to solve my problem?
Thanks for checking my mistake. I have edited it.
