Menu

Advanced Excel Function

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

Advanced Excel Function

use datafilterautofiltercustomyour formula

--
Don Guillett
SalesAid Software

"R. Fisher" wrote in message
...
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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
advanced percentage function	EG	Excel Discussion (Misc queries)	2	March 28th 09 12:48 AM
Advanced if function??	5tacey	Excel Worksheet Functions	2	March 25th 09 05:39 PM
Advanced Function help	akemeny	Excel Worksheet Functions	5	October 9th 08 03:14 PM
advanced use of the Excel lookup function	Norm	Excel Discussion (Misc queries)	2	October 12th 06 01:27 PM
Advanced IF function	wrinkle35	Excel Worksheet Functions	2	September 28th 05 09:13 PM

All times are GMT +1. The time now is 03:45 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement