?- Creating a "parts order" list from a workbook

[Mario]

Hi group,

What I would like to do is create a tools/parts list from a workbook that
contains 8 different sheets of inventory.

What I have is an inventory of tools (in a locked tool room) divided up into
8 worksheets for different sections of the tool room. So next time
inventory is done and a 0 (zero) is entered on any of the worksheets another
worksheet (sheet 9) will be updated with a list of parts & part numbers to
order.

part qty
sheet1 -- 10mm wrech | 0
sheet2 -- 17mm socket | 0
sheet3 -- fuel guage | 0

sheet9 --
10mm wrech
17mm socket
fuel guage

What would be the best way to go about this?

I've checked the help file and even googled it. I can't seem to find
anything real specific on this. Possibly I'm keying in the wrong key words.

Thanks for any help, John ;-)

 

[Norman Harker]

Hi Mario!

Try Google searching on Duplicates or Unique

Or try:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Mario]

Hi Mario!

Try Google searching on Duplicates or Unique

Or try:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm

Hi Chip!

Thanks for that link. Also, Duplicate and Unique are two words I have not
considered when googeling. I'm fairly new to Excel. Now that I know what
it's capable of doing I 'm condidering taking a class at the local college.

Any suggestions on books for a beginner at Excel?

Thanks again, John ;-)

 

[Norman Harker]

Hi Mario!

Despite it's weight, I'd recommend Excel 2003 Bible by John
Walkenbach. You probably have the bare basics for starting with that
text. Don't worry if your version of Excel is before 2003 because
changes are well flagged.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Clyde Lomax]

Santa brought me 2 books this year, The EXCEL Bible & EXCEL 2003 Formulas
both by John Walkenbach . Santa bought them at Amazon with no shipping and
no state tax and I have really enjoyed them.

Lomax

Hope all have a Happy New Year

 

[Norman Harker]

Hi Clyde!

Re:
"Santa brought me 2 books this year, The EXCEL Bible & EXCEL 2003
Formulas both by John Walkenbach"

You were obviously a good boy this year!

If you are good in 2004, perhaps Santa will get you John Walkenbach's
Excel 2003 Power Programming with VBA.

Make sure that you give a review on the Amazon.com site as I think
they are very useful.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
news:wiKHb.19344$Fg.7261@lakeread01...

 

[Mario]

Hi Mario!

Despite it's weight, I'd recommend Excel 2003 Bible by John
Walkenbach. You probably have the bare basics for starting with that
text. Don't worry if your version of Excel is before 2003 because
changes are well flagged.

Santa was nice and gave me $100 in gift certificates for Staples. I'll
check there first.

Much appreciated, John ;-)