+ Reply to Thread
Results 1 to 1 of 1

vba to extract partial text from specific columns and merge the in a specified column

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,060

    vba to extract partial text from specific columns and merge the in a specified column

    I have worksheet named calculations , need to split drinks code from columns D,W Y ,and insert data in column J.

    Column M,N,O, does the split by formula based on J.

    column Z represent the multiplication column W and Y .

    the litrage need to be extracted from column G

    to extract data from column W,Y and G to insert it in the format of column J.

    The tricky parts are those who are highlighted in yellow, need to extract data in Z and G for J as these are packs of 6 and 12 as specified in column G where the percentage of alcohol need to be extract E.G 15D represents 15% translated in column R as 0.15.

    All wines products are taken by default 75 cl then translated to column P as 0.75(tricky description image) but some will be recognised by column H which has a special code 22042190,however take note some have litres description note most of them is derived from french conversion CL that need to be converted in litres from column O to P
    However to ease the situation there is a list of code sheet tab drinks to know which item are drinking liquids .
    The list is exhaustive as it has to be done manually

    Columns M,N ,O ,S,T,U,V have formula which are derived from column J where a vba code is needed as it very painful with more of 3000 lines per day .

    Can any one assist
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by JEAN1972; 08-17-2017 at 11:30 AM.

+ 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] Extract partial text from cell
    By triaji in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2017, 11:30 PM
  2. Extract Numbers and specific text from column
    By StampedingSeve in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-09-2017, 12:55 PM
  3. [SOLVED] Help to extract partial text from a cell
    By doublew in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-12-2014, 02:00 PM
  4. [SOLVED] Find Partial text in an array and extract charaters to right
    By jenita.kurlawala in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-02-2013, 08:03 AM
  5. [SOLVED] Merge/unmerge based on whether specific text is present in a column
    By susanbarbour in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2012, 09:08 AM
  6. [SOLVED] formula to extract partial content (text) of cell
    By milano in forum Excel General
    Replies: 3
    Last Post: 11-09-2005, 01:00 PM
  7. Extract rows with specific text in a column
    By TroyB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2005, 01:06 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