Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi!
I have a strage situation: - around 50 excel files; - each excel file with 200 sheets; In each sheet I have to cell with the same content: cell A35 has content: =A34+1 and the cell A40 has content =A34+1 I want to find replace in all sheets from one workbook and search for A40 and replace the conten with: =A39+1 How can I do it? I searched a lot on internet before to ask and no answer... Thank you! gabi http://fotoblog.ro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Find and Replace in one function | Excel Worksheet Functions | |||
Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
Using Find and Replace All | Excel Worksheet Functions | |||
Multiple sheets selected | Excel Discussion (Misc queries) |