This isn't so much a workbook security question as it is just a basi
programming question. I'm a total newbie on this and only have C++ an
HTML experience, but I understand how macros work also (it's prett
basic, but I have used them).

I have two worksheets, one with a list of sites. Each site is assigne
a password through a very simple proccess. Each site is actually a 1-
digit number. I split the digits up, and multiply each digit by a see
number of 4-7 (depending on how many digits the site has), and the
concatenate that with standard text. Here's an example.

Site 766

Value-----------Seed-------------Key-------------PW
--7-----------------6-----------------42-------------dog42
--6-----------------5------------------30------------dog30
--6-----------------4-----------------24-------------dog24

A 4-digit password would have its first digit start with 7 as a seed.

So I got that working. I created a worksheet in which you enter in
site number, and it pops out a password. Easy enough with simpl
functions. Now, I have a separate database of site numbers. I've als
included their respective passwords. One digit sites have only
password, but 4 digit sites have 4. Each site begins with their firs
password (dog42 in the ex) as their current password. But, when th
user wants to, he/she just enters in their site number in that form
mentioned earlier, and it should pop out the next password. If it onl
has one pw, it will output the same one. If it's on its last pw, i
will output its first again.

In my database sheet, I added a column for the current pw, and a colum
for the next pw. The problem I have is updating them once a user enter
a site number. Can this be done with macros? Thanks in advance for an
help

--
Message posted from http://www.ExcelForum.com