+ Reply to Thread
Results 1 to 6 of 6

Search and replace

  1. #1
    Registered User
    Join Date
    07-11-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    2

    Question Search and replace

    Hi all,
    *
    I´ve made the formula below for a weekly followup worksheet, the formula is therefor present in 52 sheets and I need to remove the "week part" from the formula. Thing is I have from week 1 to week 52, the rest of the formula is the same.
    *
    how do I remove the highlighted part without having to go through all 52 sheets?
    *
    =(IF(F7="";0;F7-E7)+IF(F9="";0;F9-E9)+IF(F11="";0;F11-E11)+IF(F13="";0;F13-E13)+IF(F15="";0;F15-E15)+IF(F17="";0;F17-E17)+IF(F19="";0;F19-E19)+IF(F21="";0;F21-E21))-'week 1'!K6
    *
    Thanks in advance!
    xlsmNewbie

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: Search and replace

    CTRL-H

    Find: -'week 1'!K6
    Replace: (nothing)
    Within: workbook
    Replace All
    Glenn



  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,079

    Re: Search and replace

    @Glenn, I think that his references are like week1, week2, ...., week 52, so is not gonna work with Ctrl+H.

    @xlsmNewbie, try the solution found here: https://stackoverflow.com/questions/...e-for-formulas
    Click the * to say thanks.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: Search and replace

    Yea. You're probably right!!

  5. #5
    Registered User
    Join Date
    07-11-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    2

    Re: Search and replace

    Thank you for your inputs.

    Glenn, Just as Paul mentioned the sheets are named from week 1 to week 52, otherwise as you posted ctrl-H would´ve worked

    Paul, Thank you for the link, I looked into it but found a simpler way. By ctrl + selecting each sheet with the formula present I could change the formula in the first sheet and they would change in the other 52 aswell. The sheets do need to be identical though, which luckily they are.

    Again thx for your inputs!

  6. #6
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,079

    Re: Search and replace

    Please mark the Thread as Solved from Thread Tools if your problem has been resolved. Thanks.

+ 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. [SOLVED] Search and replace
    By sungen99 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2018, 07:59 PM
  2. vba Search and replace
    By xtrato in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-05-2016, 01:04 PM
  3. Search and replace
    By oracle765 in forum Excel General
    Replies: 1
    Last Post: 03-24-2013, 09:16 PM
  4. Search and replace VB with VB
    By Mayweed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-14-2011, 08:02 AM
  5. Limit Search & Replace's Replace All?
    By Bob@1800-mail.com in forum Excel General
    Replies: 4
    Last Post: 08-03-2006, 02:00 PM
  6. Search and Replace
    By Abdul in forum Excel General
    Replies: 2
    Last Post: 03-23-2006, 10:45 AM
  7. [SOLVED] Search and replace
    By Subu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03:05 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