Hi All,

1) Is it possible to generate a Unique No Code (e.g RV00001) in a cell so
that whoever accesses that file and when he saves it as some other filename,
gets a unique no on his excel copy & that unique no is also retained as the
last-no-used on the original excel sheet.

2) Now whatever he entered will be automatically entered on a diff
workbook's worksheet called say the 'Database' & in a database like manner,
i.e Records(rows of records).

I am new to VBA & not quite used to it. See my post "Creating a Database" as
of nov 15th.

Could anybody help me on this?

Thanking you in advance,


Eijaz