how to find and replace content of a specific cell based on its ad

  • Thread starter Thread starter IVUSKA
  • Start date Start date
I

IVUSKA

I have a workbook with large amount of sheets and I need to replace in cell
A8 in each sheet its content with text XXX, but the former content of the A8
is not the sam, in each cell is different. Is there anyway how to do it at
once so i dont have to do it for one sheet by one? Is it possible to replace
with a formula? Is it possible to replace like this range of cells?

thank you in advance for your help
 
Hi,

Hold down the CTRL key and click each sheet tab to 'Group' them and then
enter XXX in A8 of the sheet that's visible and it will be in A8 of all
shets. Don't forget to 'Ungroup' them by clicking on a sheet tab when you've
done this.

Mike
 
R-click sheet tab and pick Select All Sheets. Now Edit A8, all sheets
will have the edit. R-click Tab, select Ungroup
 
Back
Top