+ Reply to Thread
Results 1 to 6 of 6

Find replace in selected cell over multiple worksheets

Hybrid View

robnsd Find replace in selected cell... 01-04-2016, 03:54 PM
PeteABC123 Re: Find replace in selected... 01-04-2016, 04:03 PM
robnsd Re: Find replace in selected... 01-04-2016, 06:20 PM
newdoverman Re: Find replace in selected... 01-04-2016, 04:04 PM
robnsd Re: Find replace in selected... 01-04-2016, 06:24 PM
popipipo Re: Find replace in selected... 01-04-2016, 04:05 PM
  1. #1
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Find replace in selected cell over multiple worksheets

    Select all the worksheets that have the formula that you want to change. Go to BH7 and change the formula. The formula has now been changed in all the selected worksheets. Right click on the worksheet tabs and choose Ungroup and all the worksheets will become separate once again.

    Whatever you do to one of the grouped worksheets is done to all of the grouped worksheets.

    If the worksheets are placed together, click on the first one, hold down the shift key and click on the last one then all the worksheets will be grouped. If you have only the 93 worksheets in the workbook, right click on a worksheet tab and click on Select All Sheets which will do the same grouping of all the worksheets.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  2. #2
    Registered User
    Join Date
    04-25-2014
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Find replace in selected cell over multiple worksheets

    Thank you, but the formula in BH7 is not the same on all workhsheets.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 05-03-2014, 04:18 PM
  2. [SOLVED] Find and Replace across multiple worksheets?
    By Sandman13 in forum Excel General
    Replies: 8
    Last Post: 09-02-2013, 12:03 AM
  3. find and replace multiple values across multiple worksheets
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2012, 10:48 AM
  4. Find and Replace in selected cells only
    By Davidns in forum Excel General
    Replies: 5
    Last Post: 03-20-2012, 05:05 AM
  5. Replies: 2
    Last Post: 10-28-2011, 09:15 AM
  6. Multiple Cell find and replace?
    By Mark121 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2007, 12:22 PM
  7. Replies: 1
    Last Post: 04-19-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1