+ Reply to Thread
Results 1 to 4 of 4

Look for values/text in columns and Flash Fill-VBA

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Look for values/text in columns and Flash Fill-VBA

    i have copied a file in which Column A and Column B has distributed Data. I want a vba code to look for these values/texts in column A and Column B and flashfill them accordingly to the next value.
    Attached is the Workbook and snapshot of Data.
    I have written a code for some values but it,s not dynamic nor it looks for values. i have 1000,s of rows, it will be difficult to write a manual code for every value..
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Zahid0111; 04-15-2020 at 10:32 AM.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Look for values/text in columns and Flash Fill-VBA

    Possibly...
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Pakistan
    MS-Off Ver
    365
    Posts
    242

    Re: Look for values/text in columns and Flash Fill-VBA

    Wow great this works fantastic..Thank you danglor..

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Look for values/text in columns and Flash Fill-VBA

    You're welcome!

+ 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. Is it possible to Flash Fill Series without formatting?
    By Modify_inc in forum Excel General
    Replies: 3
    Last Post: 11-19-2019, 02:42 PM
  2. Replies: 4
    Last Post: 04-09-2019, 03:29 PM
  3. Flash Fill (or some other option)?
    By mcdonama in forum Excel General
    Replies: 4
    Last Post: 01-30-2019, 06:00 PM
  4. Flash Fill Help
    By shadezula816 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2017, 08:09 PM
  5. Flash Fill with No Flash fill
    By bgrish3 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 07-15-2016, 12:03 PM
  6. Auto fill / flash fill not working with formulas?
    By mhorga in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-18-2016, 12:54 PM
  7. [SOLVED] How to get excel to flash fill by learning changes to formula
    By dhingsa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-22-2015, 07:59 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