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

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

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

Group (ALL) your sheets - Enter the New Value in A8
Immediately -- UNGROUP your Sheets

"IVUSKA" wrote:

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

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

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

"IVUSKA" wrote:

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

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

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

IVUSKA wrote:

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

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

hey guys thx a lot it really works... u r soooooo cooooool.... u made my day:-)

"IVUSKA" wrote:

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