Results 1 to 14 of 14

VBA to insert column based on condition for matching col data

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2017
    Location
    US
    MS-Off Ver
    7
    Posts
    23

    VBA to insert column based on condition for matching col data

    Hi,

    I want to insert a new column at the end into child sheet and rename as "My Output".
    In that column, I need to populate the flag 1,2, 3, 0 based on data matches between parent and child sheet. I have mentioned the criteria within the spreadsheet.

    Attaching sheet for reference

    The product searching should be based on pattern matching. It means if product name as 'Paracetamol' in child sheet is searching for the product column in master sheet and if the name found to be paracetamol syrup, then it should be considered as matching.( as part of it is matching). Similar condition applicable in vice versa

    Could anyone please help me.
    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. [SOLVED] Insert column and populate data based on condition
    By tikistat in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-09-2017, 12:51 PM
  2. Insert data rows based on a condition for measured data
    By JosipK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2015, 02:09 PM
  3. Replies: 2
    Last Post: 04-11-2014, 12:18 PM
  4. [SOLVED] Insert Row based on Condition and add data in the newly created rows
    By Omariss in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2013, 04:27 AM
  5. Copy required data based on matching condition
    By raghav.k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2011, 01:35 PM
  6. insert text based on vlookup condition in two column
    By isabella in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-10-2010, 09:19 PM
  7. matching data based on column
    By Mr_Shore in forum Excel General
    Replies: 1
    Last Post: 09-25-2008, 06:30 AM

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