Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Excel Function
Not real sure how to describe this (I have a sample worksheet I can email)
Excel worksheet, 2 tabs. 1 is an order entry form: r1 Order Category 1 r2 qty Description Price Extended r3 1 item 1 $5.00 $5.00 r4 2 item 2 $2.00 $4.00 r5 0 item 3 $7.00 r6 0 item 4 $9.00 r7 1 item 5 $4.00 $4.00 r8 r9 Order Category 2 r10 qty Description Price Extended r11 1 item 6 $10.00 $10.00 r12 0 item 7 $6.50 r13 0 item 8 $9.95 r14 r15 Order Category 3 r16 qty Description Price Extended r17 0 item 9 $3.00 r18 0 item 10 $4.00 .. .. .. Tab 2 is the invoice / order form What I would like to do is copy the rows from tab 1 to tab 2 but only for those rows where the extended amount is 0. In other words, in the above example only use r1,r2, r3,r4,r7,r9,r10 & r11 and not use r5,r6,r12,r13 and not use r15 to r18 at all because there is no extended prices for the items in Category 3. While I am at it (and not to be greedy about asking), I would also like to copy the cells the way they are formatted over to tab 2. The height of the row, the shading color of the cell, the text color, etc. Any thoughts? Thanks so much in advance. R. Fisher |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Excel Function
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced percentage function | Excel Discussion (Misc queries) | |||
Advanced if function?? | Excel Worksheet Functions | |||
Advanced Function help | Excel Worksheet Functions | |||
advanced use of the Excel lookup function | Excel Discussion (Misc queries) | |||
Advanced IF function | Excel Worksheet Functions |