Results 1 to 11 of 11

Fastest method to search BT column for value starting with "27W" and then adjust adjacent

Threaded View

  1. 09-02-2015, 01:59 PM #1
    ks100
    ks100 is offline
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    Fastest method to search BT column for value starting with "27W" and then adjust adjacent

    What is the fastest method to search the "BT" column (entire used column) for any value starting with "27W", and then change the value of the BV column in the same row to "my string"?
    Last edited by ks100; 09-02-2015 at 02:24 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find a word "screenshot" and print value "yes" in adjacent Column
    By prat123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2015, 03:04 PM
  2. Formula help - search multiple columns for text "starting with" names in a named range
    By lcgeek in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2014, 03:00 PM
  3. Update Macro to search column Bfor "Fail" and "Exception"
    By programct in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2014, 02:32 PM
  4. Data Analysis ("Fastest column"?)
    By DataGeekXLS in forum Excel General
    Replies: 8
    Last Post: 01-25-2013, 08:43 PM
  5. Needdrop down menu with two choices as "High Interest Rate Method" and "Snowball Method."
    By sqlindia in forum Excel General
    Replies: 2
    Last Post: 09-25-2012, 12:53 AM
  6. Range.Find method - Address meeting search criteria in r,c rather tha "A3" (say) format
    By Hafod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2012, 06:32 AM
  7. Search all rows on Sheet1 for cells in Column "C" that contain "PD" and if found cut
    By STEVEB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2008, 04:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1