Dynamic Excel Order Form
Budget: $250 – $750 USD
We have a static price sheet in excel that looks like this :
SKU | Description | Price | Case Pack
ENG1 | 65Qt Coolers | $100 | 1
UC2 | 15Qt Dry Box | $50 | 4
I would like a second sheet in the excel document :
The top headers should have standard fields :
Company Name
Bill To Address
Ship To Address
Order Date
Order Number
Contact Name
Phone Number
Rep Name
Then below that would be dynamic columns
SKU | Description | Price | Quantity | Extended Price
The SKU column should pull a drop-down populated from the price sheet.
When they pull down to an SKU, it should automatically fill out SKU, Description & Price columns.
The customer can then enter a quantity and it will complete the extended price (Quantity x Price)
They can add as many rows as they need.
Then below the last row that is entered, it should have Shipping & Total.
Shipping would simply be "TBD" or $0. It would automatically be changed to $0 if the total is over $2000.
SKU | Description | Price | Case Pack
ENG1 | 65Qt Coolers | $100 | 1
UC2 | 15Qt Dry Box | $50 | 4
I would like a second sheet in the excel document :
The top headers should have standard fields :
Company Name
Bill To Address
Ship To Address
Order Date
Order Number
Contact Name
Phone Number
Rep Name
Then below that would be dynamic columns
SKU | Description | Price | Quantity | Extended Price
The SKU column should pull a drop-down populated from the price sheet.
When they pull down to an SKU, it should automatically fill out SKU, Description & Price columns.
The customer can then enter a quantity and it will complete the extended price (Quantity x Price)
They can add as many rows as they need.
Then below the last row that is entered, it should have Shipping & Total.
Shipping would simply be "TBD" or $0. It would automatically be changed to $0 if the total is over $2000.