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

  • Thread starter Thread starter Mario
  • Start date Start date
M

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 ;-)
 
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.
 
Norman Harker said:
Hi Mario!

Try Google searching on Duplicates or Unique

Or try:

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


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 ;-)
 
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.
 
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
 
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...
 
Norman Harker said:
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.
Click to expand...

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

Much appreciated, John ;-)
 
Back
Top