ordered

I have a simple sheet that looks like this: more data And, I'm using the following code within other code in VBA: With ActiveSheet.Sort .SortFields.Add Key:=Range("J1"), Order:=xlAscending .SortFields.Add Key:=Range("C1"), Order:=xlAscending .SetRange Range("A1:V" & LRX)...

Hello, I have been racking my head on how to solve my time issue on my train sheet. I have a train time sheet to show if a train is on time or late Ex; if a train is set and ready to go at 01:30 and the crew is ordered at 03:30 i can show it to say 2:00 on time between these two times. but...

I created a table to record ordering items, and have 2 columns (a Date, and a Qty) for each week of the year, per quarter, to record the Date Ordered and Quantity Ordered. I have 2 columns (at the end of each quarter) which I want the Last Date Ordered to appear in one column, and Last QTY...

I have a sheet with the column headers as dates by month and year. Column A is "Jan 2002", Column B is "Feb 2002" etc until Column HC "May 2019". In Column HG I have a the date of the last time my customer ordered "Aug 2007" for example. For each month there is either a dollar amount or it is...

Hi All, I am trying to complete a parts ordering system for work with my limited excel knowledge. I currently have 15 worksheets with various names & each sheet has 5 x columns: A=Item B=Description C=Cost D=Order E=Total. What I need to happen is when a quantity is entered into Column D, that...

I have 4 reports that I get The data in these reports is simple, It contains one column with the customer code and a second column with an order entry date The 4 reports are Orders for the last two years Orders for the last Month Orders for the last 3 weeks Orders for the last two weeks I...

Hi mvps! My goal is to find out the vendor that the customer ordered from. In my lookup table (AP Report), I have the vendor name, and my criteria columns: customer name, itemnumber and the posting date. The customer and item number are exact matches, the posting date however, can be the same...

hi, I have the formula below which works perfectly until it returns 0 if nothing is found Can I have the formula changed to show "Ordered" if 0 is found =IF(ET3&EV3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(('Chase Details'!$F$10:$F$1009=ET3)*('Chase Details'!$G$10:$G$1009=EV3)),'Chase...

Hello, I'm new at this and trying my hardest to create a pivot table that reads multiple worksheets in my file - but I keep hitting brick walls! I'm wondering if anyone is able to help me, pretty please? My file is for someone who has customers ordering beauty products from her. Each...

I have data in longitudinal format for patients. Each row denotes a treatment with patient column for Patient ID and date of treatment. I need a formula to work out an ordered count for each patient for their first treatment, second treatment, third treatment etc.

Hello, I need to figure out how to grab the 2nd largest value with criteria and avoiding duplicates. essentially i have a list of transactions and I need to say what is this customer's last time they ordered and 2nd to last time they ordered. Thank you so much!

Hi, I want to know if what I am thinking is possible and if so what should I Google to find out more? I have 5 workbooks, each workbook represents five different branches of a company and each workbook has worksheet tabs from January to December (12 tabs in total) in which an invoice is for...

In column A I have over 10,000 inventory items where there are some duplicates. (I cannot remove the duplicates this list has to remain in this order) in Column B I am entering the amount that I need to order Is there a way when i enter a qty in column b and I have already ordered that item...

Is it possible to loop through a series of textboxes to create an array in a specific order? In a userform, I have 17 textboxes named "txtG1" through "txtG17". I would like to loop through and build an array to pass to the workbook vs. passing each value independently. The code below loops...

Hello Guys, I have my sales report in a table starts from column I7 to M7. In I column i have my product name, in J column order status and in M column quantity of the product. My requirement is IF cell content in J column reads ordered and M column cell content reads quantity as 5, then the...

Hi guys, I want to obtain the sumproduct of the following two arrays, essentially 1 x 0.2 + 2 x 0.1 + 3 x 0.3. A 1 B 2 C 3 B 0.1 A 0.2 C 0.3 SUMPRODUCT would work neatly if the first column in both these arrays were identically ordered (i.e. ABC and ABC). But because they're not so, it...

Hello All, I am trying to count orders placed from one sheet in a workbook to another sheet. I'm trying to do it by part number and month range. For instance, I have sheet1 that I keep a running tab of orders placed; part #, date ordered and quantity. On sheet two, I have; description, part#...

I'm pretty clueless when it comes to coding and need some help with this excel file. I'm trying to insert a code that will move an entire row from sheet "Ordered" to sheet "Invoiced" when yes is selected from the drop down list in column M. I'd like it to not leave any blank lines on the...

Hi All, i am trying to set up a small system so i can scan a barcode from my android phone which then refers to a barcode master sheet (that i can replace at any time) to look up info and then puts that info ito a spreadsheet. info would be as follows in colums:- barcode, model, description...

Hello. Is there a way to use other functions with the SUMBYCOLOR function? I've not been able to get it to work. I would like to sum data that has a specific background color, within a specific date range, containing specific text "Widget #1 " or "Widget #2 ". Example: Summarized data should be...