inv

Hello, Please I need your help I'm trying to find a value reference to two columns, I'v tried it in Excel worksheet, it works fine, but I'm not able to use it in VBA Here is the function that I tested in Excel worksheet in range (I2) and works fine =INDEX(E:E,MATCH(1,(A:A=G2)*(B:B=H2),0))...

This is in reference to the following thread for the top 5 customers and their respective totals: https://www.mrexcel.com/forum/excel-questions/1100836-formula-macro-vba-match-top-5-outstanding-amounts-offset-name.html I have tried to make the formula work to eliminate 3 customer names from...

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody> Hello all. I have a head banger issue. Any and all help is a greatly appreciated. This data is exported from an application. I am working with Excel 2016. My attachment shows the...

Hello to all I'm not sure how to approach this problem. This first table is the end result I am looking for. The data I pull down from my accounting system is in the second table below. It exports to excel 2016 as it is shown. It is basically a GL detail report. I am only concerned with 4...

Hi, I am looking to return multiple text/numbers from different cells based on one or more criteria but to return these all in one cell. Example A B PO Inv No Inv No PO 7654 121 121 7654 7458 7422...

<tbody> <tbody> INV REIN BON WD INV REIN BON WD INV REIN BON WD </tbody> </tbody> <tbody> 10 20 30 40 100 50 20 30 40 50 20 40 </tbody> Hi everybody, i am searching for a formula that gives me the column number when the sum...

Hello Everyone, First time poster, the following query works just fine in access: However, when I try to connect it to VBA it doesn't work: I get a runtime error '2147217887 (80040e21)': Automation Error Code and query below Select a.str, a.name, b.dpt, c.desc, sum(b.[Sales TY]) AS...

Hello Everyone, First time poster, the following query works just fine in access: However, when I try to connect it to VBA it doesn't work: I get a runtime error '2147217887 (80040e21)': Automation Error Code and query below Select a.str, a.name, b.dpt, c.desc, sum(b.[Sales TY]) AS [Sales...

Hello Everyone, Does anyone know of a way to turn multiple Columns into one column. For example, I am looking to have one column with 20/40, 30/50, 40/70 and 100M. Then the other columns will contain Avg LT, Replenish LT etc. Please note this is actually 95 total columns with multiple...

Hello, & thank you for any help you may offer! I tried to search the forum but could not find an answer to my issue. I have a powerpivot table from my data model with 6 columns, & (currently) 2 filters (wanting to add a 3rd but need to figure out the relationships- different issue). 3 of the...

Hello in PL!P2, input as SC1, PL!P2 & PL!P3 is set with the formula below which returns details in worksheet inv! depends on PL!P2 and column C and D of invoice page. How to replace the part -4 in PL!PL3 because the -4 is changeable according the position of SC# in worksheet inv PL!P2 (SC#)...

Hello, I need an if statement with multiple conditions. I know that I should be using OR and AND in the formula but I have not clue how to write it but nor am I am even sure if it can include this many conditions. Below is what I need to be in the entire formula. If N2 = Mismatch AND O2 =...

Hi all, I would like to write a VBA code with below command - If Col. “B” contains the letters INV and INV1 should move the data from col. “D” to "B" and data from col. “E” to “D”. Below in sch.1. are the data and in sch.2. is the expected result Thanks in advance <!--[if gte mso 9]><xml>...

Dear Sir I make Invoice in excel and i need a pop up box with message "E WAY BILL REQUIRED" when below conditions are met When Total INV VALUE cell "L44" >= 100001 and CGST Value cell "L42" =>1 then box should pop up In the same Invoice When "IGST" value cell "L40" >=1 and Inv Value "L44" >=...

I'm using Excel 2016 I have 2 different worksheets in 1 workbook. First worksheet (Sales) is sales from a POS system - which is already subtotaled By Item / By Profit Center. Second worksheet (INV Tx) is Inventory from an accounting system - which was NOT subtotaled detailing how many of...

Condition: If Credit Note value & Party Name are same then latest date of invoice & it's no should come in desired invoice no & date coloumn <colgroup><col><col><col><col><col><col></colgroup><tbody> NAME Inv No Inv Date CEDIT NOTE Desired Inv No Desired Date A 217975312 03-Jan-17 833743881...

I have a series of alpha values in column "I" and a control group of values in column "B". I need to find any missing values in column "B" that may exist in column "I". Example- Column I has: P, BS, SS, A, W, P, INV Column B has everything except P and INV. This is a simplification, there...

I am working with a script that will save a SHEET from my workbook to a location on my computer but it opens it up also. SO I am trying to get that NOT to open or at the least we I can get that file to close. Here is where I am at now: Application.DisplayAlerts = False ActiveSheet.Select...

Dear Friends, I want a help for a formula which will calculate covered invoice Nos & Inv dates based on Fruit & that particular Fruit's stock. Giving an example below: Sheet1 <colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col...