Results 1 to 2 of 2

Need to find and replace with work sheet name part of a formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2015
    Location
    dhaka,bangladesh
    MS-Off Ver
    2007
    Posts
    12

    Need to find and replace with work sheet name part of a formula

    Hi
    in the attachment i a work book where i have a sheet named final status & another 2 sheet named w-5961 and w-5801.
    i made summery in final status file for the information of w-5961 and w-5801.

    all the cells has a formula in the summery field for w-5801like
    =INDEX('W-5801'!$S$2:$S$19967,MATCH($B3&"#"&E2,'W-5801'!$M$2:$M$19967,0))

    now i need summery for w-5961, using same formula just changing to w-5961 instead of w-5801.

    i did it here manually, how can i find and replace it.

    pls help.

    thanks
    aripori
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add work sheet, find and replace macro help!
    By Snaybot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-13-2014, 01:36 PM
  2. Find and Replace part of formula using VBA
    By chococ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2014, 01:26 PM
  3. [SOLVED] Find/Replace part of a formula (with only an opening parenthesis)
    By yanweifelix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2014, 09:30 PM
  4. find and replace part of formula only
    By iceshimmer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-06-2013, 06:51 AM
  5. Find and replace date in a work sheet
    By pohaku in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 11-18-2007, 07:25 PM

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