I am working on doing inventory and my boss would like a spreadsheet where we
can enter our inventory for this year and automatically copy the items we
need to another spreadsheet to print and order from. Basically, we have
columns with the inventory information (item, brand, description, order size,
etc) and then three columns indicating what we have in stock, how many we
need total, and how many we need to order for next year.

What I would like to do is take any of the items that indicate that we need
to order them (0 in the to order column) and copy all the information for
that item to a new spreadsheet so we dont have to search and manually copy
and paste every year what we need to order.

I'm sure this is a simple thing, but I'm not very well versed in excel lingo
(I can do basic functions but unfortunately, I'm the most qualified here
because I am "the youngest and grew up with computers so I know how to turn
the computer on")

Any help would be appreciated...especially if you can make it like Excel for
Dummies or something!

Here's a simple play which delivers what you seek

Assume source table in Sheet1's cols A to H,
data from row2 down, where the key col = col I ("To order" col)

In Sheet2,
In A2: =IF(Sheet1!H20,ROW(),"")
Leave A1 blank

In B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX(Sheet1!A:A,SM ALL($A:$A,ROWS($1:1))))
Copy B2 to I2. Select A2:I2, copy down to cover the max expected extent of
data in Sheet1, say, down to I200? Minimize/hide away col A. Cols B to I will
return only the required lines from Sheet1 (0 in the "To order" col), with
all results neatly bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MB_HCAthleticTrainer" wrote:
I am working on doing inventory and my boss would like a spreadsheet where we
can enter our inventory for this year and automatically copy the items we
need to another spreadsheet to print and order from. Basically, we have
columns with the inventory information (item, brand, description, order size,
etc) and then three columns indicating what we have in stock, how many we
need total, and how many we need to order for next year.

What I would like to do is take any of the items that indicate that we need
to order them (0 in the to order column) and copy all the information for
that item to a new spreadsheet so we dont have to search and manually copy
and paste every year what we need to order.

I'm sure this is a simple thing, but I'm not very well versed in excel lingo
(I can do basic functions but unfortunately, I'm the most qualified here
because I am "the youngest and grew up with computers so I know how to turn
the computer on")

Any help would be appreciated...especially if you can make it like Excel for
Dummies or something!

Typo:
.. where the key col = col I ("To order" col)

should read as:
.. where the key col = col H ("To order" col)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks for the response. I tried to follow what you did, but I must've
goofed somewhere. I copied that formula into sheet 2 A2. Do I leave the row
part blank or should I select something for that? Also, I'm not 100% sure
what I'm doing with B2. You said to copy B2 to I2 and I dont know why/where
I would do that. Are you saying to take the information from sheet1 and copy
it into sheet2 starting in B2? I tried that and it didn't work, but again,
I'm sure I've missed something.



"Max" wrote:

Typo:
.. where the key col = col I ("To order" col)

should read as:
.. where the key col = col H ("To order" col)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Leave A1 blank ..
means just that, not to enter anything into A1

.. not 100% sure what I'm doing with B2... etc

Why not take a look at this sample file which shows you
how the earlier set-up should look like, and working fabulously:

http://www.freefilehosting.net/download/3hg3d
Order Lines to new sheet.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MB_HCAthleticTrainer" wrote:
Thanks for the response. I tried to follow what you did, but I must've
goofed somewhere. I copied that formula into sheet 2 A2. Do I leave the row
part blank or should I select something for that? Also, I'm not 100% sure
what I'm doing with B2. You said to copy B2 to I2 and I dont know why/where
I would do that. Are you saying to take the information from sheet1 and copy
it into sheet2 starting in B2? I tried that and it didn't work, but again,
I'm sure I've missed something.