Building an order summary

[Closed]

Report

Rasheed - Feb 25, 2018 at 01:41 PM

Hello,

So I have an order form with a list of SKUs. If you enter a quantity next to any SKU the form then the price and totals show up. If you don't choose any quantity for a given SKU then no price is calculated and nothing is added to the total.

So lets say there are 5 items on the form and 3 of them have been chosen.

SKU QTY PRICE EA. TOTAL
R43 3 $10 $30
R44
R76 7 $7 $49
S87
S38 2 $16 $32

I need to get the summary to only have 3 rows and drop the blank rows. And I don't mean to copy the rows, I mean to look at the table above and copy the content of a cell with a value and then move to the next cell with a value and copy that.

So it could look like

SKU
R43 3 $10 $30 in stock
R76 7 $7 $49 in stock
S38 2 $16 $32 no stock
Can this be done? I think this is like searching an array or something but I've no idea how to do it.

Building an order summary
Summary slide powerpoint - How-To - Powerpoint
Could not build a preview because there is not enough memory (ram) - How-To - Photoshop
Nasm build - How-To - Languages
How to check windows 7 build version - How-To - Windows 7
Windows 7 build 7600 this copy of windows is not genuine free download ✓ - Forum - Windows 7

Building an order summary

Your reply

Subscribe To Our Newsletter!