If i understand you right, you have a stock inventory that you want to keep
track of. adding and deleting sock items as you go. Yes, you can write a
macro and yes it can stay in the same workbook


"james9662" wrote in message
...
We have an Excel workbook that tabulates parts from entering parts needed
and
we need to have the inventory number stay and it is changed and be able to
delete old entries and start new worksheets and have the inventory stay
from
the last set of entries. I am not proficient with macros, so I would need
help here more than just say "Write a macro.", DO I have to link to a
seperate data base or excel sheet or can I do this in the same workbook?

Thanks,
Jim