Hi DS, thanks for the help before. I have modified my needs a bit and of
course have no idea how to get there. Anyone else is certainly welcome to
help.
problem:
I need to have several workbooks that are titled by year (for autos)
in each are several tabs(sheets) the equal the unique auto number.
On each of the sheets are various descrepencies found for each auto.
so, I now have a number generator. Can I set it up so that all sheets and
workbooks are linked in a way that when a workbook is opened and a particular
auto selected: a new descrepency is to be entered manually, when the operator
clicks on the column "waiver no" (the new generated number); can it it be set
to ask "new number?" yes/no, if yes it automatically goes to the new number
workbook, generates the new number and then populates the cell just clicked?
In this way the number generator workbook could just stay in the background.

Whaddaya think? any takers? Y'know, us dummies sure do appreciate you all
that help on these things! thanks, larry