allocate shipping and handling to varying number of items in an or

O

orchid11652

I receive a spreadsheet which shows the following type of sales information
(its wrapped-copy and paste to excel for review). Basically the shipping and
handling per order is summarized below each order. Each order can have
varying number products in it, one item per line. Is there any easy way to
allocate the shipping to each item within the order? So the formula will a)
recognize how many lines to divide by, i.e., stops at the previous "Shipping"
line and counts the number lines between each Shipping line and use that
number to divide the shipping charge and then populate it on each line?
Thank you.
DESCRIPTION QTY UNIT$ EXT$ SHIPPING DISCOUNT GIFT CERT TAX TOTAL
The Book 1 1 $29.99 $29.99 $0.00 $0.00 $0.00 $0.00 $29.99
The Book 2 1 $29.99 $29.99 $0.00 $0.00 $0.00 $0.00 $29.99
The Book 3 1 $49.99 $49.99 $0.00 $0.00 $0.00 $0.00 $49.99
Shipping and Handling 1 $13.95 $0.00 $13.95 $0.00 $0.00 $0.00 $13.95
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: How to find 0.00 in a column of number? 4
Varying number of rows 1
Creating a macro to line up data in 2 worksheets. 0
Calculate total amt due on an invoice. 9
VBA works in orignal but fails in copy of database 1
help with getting to end report 3
total Amt Due, Taxes, Shipping, Expense and Total Amt Due on Invoi 2
How would I add "shipping charge" to an Invoice (form/subform) ? 4

Top