Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace in mulitple tabs
Try this: Right click on your worksheet tab. Click Select All Sheets.
Change the cell in question. With all worksheets selected, whatever you do to one sheet will happen to all of the sheets - just be sure to unselect all of the worksheets when you're done (either by clicking on another worksheet tab, or right click and select ungroup sheets). "childothe1980s" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace in mulitple tabs
If you want a VB solution you could try:
Sub Macro1() ' Dim i As Integer For i = 1 To Sheets.Count Sheets(i).Range("A2").Value = "10-999999-00-100" Next i ' End Sub But I think JMB's solution is the easiest. "JMB" wrote in message ... Try this: Right click on your worksheet tab. Click Select All Sheets. Change the cell in question. With all worksheets selected, whatever you do to one sheet will happen to all of the sheets - just be sure to unselect all of the worksheets when you're done (either by clicking on another worksheet tab, or right click and select ungroup sheets). "childothe1980s" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace in mulitple tabs
Thanks, JMB!!! That worked perfectly!!!!!!!
"JMB" wrote: Try this: Right click on your worksheet tab. Click Select All Sheets. Change the cell in question. With all worksheets selected, whatever you do to one sheet will happen to all of the sheets - just be sure to unselect all of the worksheets when you're done (either by clicking on another worksheet tab, or right click and select ungroup sheets). "childothe1980s" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace in mulitple tabs
Glad to help.
"childothe1980s" wrote: Thanks, JMB!!! That worked perfectly!!!!!!! "JMB" wrote: Try this: Right click on your worksheet tab. Click Select All Sheets. Change the cell in question. With all worksheets selected, whatever you do to one sheet will happen to all of the sheets - just be sure to unselect all of the worksheets when you're done (either by clicking on another worksheet tab, or right click and select ungroup sheets). "childothe1980s" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I do a global find and replace on the tabs in Excel 2007 | New Users to Excel | |||
Move data from mulitple tabs to one sheet | Excel Discussion (Misc queries) | |||
Multiple find mulitple replace | Excel Worksheet Functions | |||
Lookup mulitple tabs | Excel Worksheet Functions | |||
Find duplicate entries within mulitple worksheets, then listing th | Excel Worksheet Functions |