Hi!
Assume the items on Sheet 1 are in column A starting in A2=20
and the quantity is in the corresponding cell in column B.
For this example the total range is A2:B21.
In Sheet 4 in whatever cell, enter this array formula with=20
the key combo of CTRL,SHIFT,ENTER and copy down until you=20
get #NUM! errors which means there is no more data that=20
meets the condition:
=3DINDEX(Sheet1!$A$2:$A$21,SMALL(IF(Sheet1!$B$2:$B $210,ROW
($A$1:$A$20)),ROW(1:1)))
Biff
-----Original Message-----
I have a workbook that has about four worksheets =E2?=A6
I want to create a list of items that will automatically=20
be included on=20
worksheet tab 4 from Worksheet tab 1 if the quantity for=20
the item listed on=20
the first worksheet has been changed from 0 to any other=20
number (i.e. 1 or 10=20
etc).
I have a list of equipment with pricing on worksheet tab=20
1 and the list is=20
long. Many of the items will have quantities of zero and=20
will not increase as=20
they will not be selected for the project being created.=20
We have additional=20
columns for cost, extended cost, labor hours etc. If the=20
quantity changes for=20
a part on any particular row, the extended cost changes=20
from 0 to x and the=20
labor hours change from 0 to x. Once the project is=20
approved, there is an=20
individual who must order all equipment that has a=20
quantity greater than 0.=20
It would be ideal for that list to automatically be=20
created on the worksheet=20
tab #4 so that this individual does not have to sort=20
through the entire list=20
of equipment that could have been selected for the=20
project (but was not). How=20
does one go about automatically creating this new=20
worksheet (tab or sheet #4).
Thanks!!!
Eddie
.
|