orders

Hi all, I have a table that is being filled out with risk orders that I have to e-mail to a customer so they can review it. There can be loads of them, so populating all can take a long time. It has to be dependant on the region (F Column) and the Sold to (E Column), so if there are two orders...

I have a sheet of about 1000 rows ... So there are 11 rows of Master Order numbers but only 5 different Master Orders. Some Master orders have Slave orders, some do not. If a Master order has a Status of 12, 13 or 14 or a Type of 02 I need to remove that row. The problem Im having is...

Hello, I'm using the Analysis tab to pull things from SAP BI - for whatever reason if it goes over a certain number of records, it either disconnects me from SAP Business Objects, or gives me a "no data" message. What I'm trying to do: I'm trying to pull all orders for all accounts, so I can...

All, Need help reformatting a data dump from my work system. Unfortunately when trying to get a dump of orders by day, with customer name, product and quantity, it puts the customer name in the same column!! I need to download 3 months worth of orders, please help! Cheers PS example attached...

Hi all, I need to change some code in my UserForm that we use toinsert orders to a WorkBook so that it incrementally updates the order number.Currently I use the code as seen below: Dim rng As Range Set rng = Cells(Rows.Count, 1).End(xlUp) rng.Offset(1) = rng + 1 ws.Cells(iRow, 2).value =...

I have three columns, 1st column has Sales peoples names in it, second column has type of order and third column has the total of the order I would like to look up all the orders for John Smith, that have been won and total the value of the orders. I was using sumifs and its not working, is...

Hello, I am using google sheets. https://ibb.co/rdwFqx8 I am using the following function in cell F2 =query($A$2:$D$1000,"select * where D is not null",0) As you can see in some orders the phone numbers are not showing (Such as order 1208 1209 1210 1215 1217) I am not sure whats going...

Hi, I am working on an Index Match function whereby I input a date in one field and a text in another field and it should return the total sales for a product for that particular month. This should bring back a value if the conditions are met. I need to have multiple criteria because my formula...

Would like to reach out to this community to ask for help. I have been creating some user forms in Excel but I am stuck when it come to creating user form to enter customer orders. Any recommendation would be greatly appreciated. User Form would generate a SO auto number 1234, however would...

I have 2 sheets . One that shows me a part number description and qty on open orders at I have through a pivot table . I have another sheet for my inventory that shows Part number description and on hand qty. I want to do a vlookup on the open orders to show me how many I have on hand to fill...

Good Evening, I have a workbook that contains a list of orders amongst vast other information. These orders may have 1-100 lines(sequences) against them but split into multiple due dates with further sequences listed as a later due date. As we anticipate the first order of the first five...

Hi All, I am having trouble creating a formula... I need the sum of verbal phone orders between 7:01AM and 11:59PM....I counted 10 (data is below) I started with the formula below, but maybe I should use SUMIFS? Or what formula can I use to get me the sum of verbal phone orders between...

Hi Everyone, Newbie here I regularly receive a spreadsheet which include merchandise orders in a column. However, if two or more items are ordered by a customer, the data is all added into a single cell in the row corresponding to their name. I then need to extract the data for individual...

Hello, I have a workbook that contains a list of orders amongst a vast amount of other information. The orders are listed by a sales order due date from oldest to newest and are repeated multiple times but referencing different line items on that order(its almost safe to assume every order will...

Hi excel gurus, I have a list of rejected orders in an excel. It has information such as rejection date, vendor, rejection type, etc. One of the analysis I want to do with it is calculate the percentage of rejections vs the total orders. The number of total orders is in another table, as the...

Hi All! I am trying to come up with some code that will 'scrape' a couple of values from a website and save those values into a couple of Excel cells, and possibly autoupdate those cells whenever the website updates those values that were scraped. The site that I am trying to scrape from is...

The formula listed below is only averaging items for "5B" and does not include items from "LI". I have tried everything I know to get it to produce the desired results. Any ideas? =IFERROR(AVERAGEIFS('WORK ORDERS APPROVED DATA'!$N$7:$N$3500,'WORK ORDERS APPROVED DATA'!$G$7:$G$3500,P11,'WORK...

I need to find a way in excel to show me the lowest amount shipments it would take to send out all of these orders, without splitting individual orders, by adding together rows that could fit under the volume threshold of 3400. Any help would be appreciated. https://imgur.com/a/X8AXTZO image is...

Hello All, I'm working on a first in first out orders vs inventory spreadsheet. <tbody>#DAE7F5[/URL] "] A B C D E F G 1 Crop Item Qty Item Order Date Qty 2 1 A 10 #000000[/URL] , align: center"] A 1/1/2019 50 3 4 A 20 #000000[/URL] , align: center"] A 1/2/2019 30 4 6 A 30...

I'm trying to create a measure that shows what orders haven't been invoiced yet. I have an invoice table with both Invoice Number and Order Number and a Order Table with Order Number. I want to to get the value of the Orders without invoice number.