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 |
Advanced Excel Function
|
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com