Home

Price list - Order form-Summary page

%3CLINGO-SUB%20id%3D%22lingo-sub-671632%22%20slang%3D%22en-US%22%3EPrice%20list%20-%20Order%20form-Summary%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-671632%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20build%20an%20Ordering%20tool.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20my%20product%20families%20(5)%20on%20individual%20worksheets.%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20are%20set%20ups%20to%20allow%20customers%20to%20enter%20a%20quantity.%26nbsp%3B%20That%20creates%20a%20discounted%20price%20and%20an%20extended%20price%20for%20all%20of%20the%20items%20in%20that%20family.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20copy%20out%20any%20lines%20that%20have%20a%20quantity%20entered%20into%20a%20summary%2Forder%20form.%3C%2FP%3E%3CP%3ESo%20this%20is%20like%20Filtering%20for%20a%20qty%20larger%20than%20zero%20and%20copying%20only%20those%20lines%20to%20a%20summary%20page.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20selectif%20kind%20of%20statement%3F%3C%2FP%3E%3CP%3EIs%20there%20another%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20your%20help!%3C%2FP%3E%3CP%3Emav%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-671632%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Mavnav
Occasional Contributor

I am trying to build an Ordering tool. 

I have my product families (5) on individual worksheets. 

These are set ups to allow customers to enter a quantity.  That creates a discounted price and an extended price for all of the items in that family. 

I would like to copy out any lines that have a quantity entered into a summary/order form.

So this is like Filtering for a qty larger than zero and copying only those lines to a summary page.

 

Is there a selectif kind of statement?

Is there another way to do this?

 

I appreciate your help!

mav

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies