Help to sort VBA data based on submission date

%3CLINGO-SUB%20id%3D%22lingo-sub-2606758%22%20slang%3D%22en-US%22%3EHelp%20to%20sort%20VBA%20data%20based%20on%20submission%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2606758%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20the%20following%20data%3A%20ID%2C%20order%20%23%2C%20submission%20date%2C%20price%2C%20submitted%20by%2C%20case.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20get%20all%20orders%20that%20are%20submitted%20today%20(column%20c)%2C%20then%20check%20their%20case%20(column%20h)%2C%20then%20count%20orders%2C%20which%20have%20their%20case%20set%20to%20%221%22.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2606758%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi!

I have the following data: ID, order #, submission date, price, submitted by, case. 

 

I want to get all orders that are submitted today (column c), then check their case (column h), then count orders, which have their case set to "1". 

0 Replies