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
Bookmarks