how do i tie together a company and its products on a excel sheet

[steppie70]

Looking for different ideas on how to do this, I have gotten one so far,
just checking.


Is there a way each time you open a worksheet the number advances, for
instance, we are using the excel program to generate bill of ladings for our
company, we need new numbers every time the b.o.l. is opened to insure we do
not use the same number twice, we would like to have a formula that does this
for us.

 

[JE McGimpsey]

Looking for different ideas on how to do this, I have gotten one so far,
just checking.


Is there a way each time you open a worksheet the number advances, for
instance, we are using the excel program to generate bill of ladings for our
company, we need new numbers every time the b.o.l. is opened to insure we do
not use the same number twice, we would like to have a formula that does this
for us.

See

http://www.mcgimpsey.com/excel/sequentialnums.html