+ Reply to Thread
Results 1 to 2 of 2

Find string Col B paste in Col A until it changes then paste new string

  1. #1
    Registered User
    Join Date
    12-26-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel for 365
    Posts
    62

    Find string Col B paste in Col A until it changes then paste new string

    Hi All,

    I have a string in Col B. XXXX.XX.XX. The first 4 do not change. Id like to find that string and copy in every row of Col A until it get to the ones that change. I have attached a file, Orig tab is my data & result is what Id like to see. Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: Find string Col B paste in Col A until it changes then paste new string

    Please empty all expected results and try in A2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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] Excel VBA - Find string and paste matching results
    By rockstar1989 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-14-2023, 06:19 PM
  2. [SOLVED] Find String, copy entire row, paste another workbook next available row.
    By marcosis in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-16-2019, 08:43 AM
  3. [SOLVED] Find value in range that matches string and paste
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-10-2017, 03:17 PM
  4. Find string(s) within a string & paste on same Row in New Column
    By noboffinme in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-25-2016, 06:51 AM
  5. [SOLVED] find date string and paste into different column, same row
    By rdowney79 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-06-2014, 11:27 AM
  6. [SOLVED] Find string in column and paste corresponding row into other sheet
    By cronerd in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-28-2013, 01:21 AM
  7. [SOLVED] Find a string, then paste that row's info
    By Hallet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2012, 05:07 PM

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