+ 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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Search and replace

    CTRL-H

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




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

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

    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... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    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
    Office 365
    Posts
    2,108

    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. Replies: 4
    Last Post: 08-03-2006, 02:00 PM
  6. [SOLVED] 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