View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
childothe1980s childothe1980s is offline
external usenet poster
 
Posts: 23
Default Find and Replace in mulitple tabs

Hello:

I have a spreadsheet with at least 30 tabs. I need to make a change on just
one cell in each tab.

Is it possible to do a find and replace on a spreadsheet all at once and on
multiple tabs in the sheet, or am I limited to just one tab at a time?

It is just one change that I need to make and it's on the same cell and the
same change for the cell is to be made on each tab. (I need to change
10-399000-00-100 to 10-999999-00-100).

Thanks!

childofthe1980s