Changing a made up password

[Nornny]

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

 

[Nornny]

For further reference, here's my "database worksheet"
V=Value, S=Seed, K=Key, and PW=Password. There are actually 4 of eac
column like mentioned above.

Site #-----V1---V2---S1---S2---K1---K2---PW1---PW2----CurrentPW
1 -----------1-----------4----------------------dog4--------------dog4
21----------2-----1----5----4-----10---4----dog10---dog4----dog10

etc etc...
I don't know if my last column will show since I maxed out the tex
box, but there's another column that is NextPW that has the nextPW i
line.

Now, I need another worksheet, I'm assuming I have to use form object
but i'm not sure. I'd like as little programming as possible since
have no VB experience. I need something where the user enters in a sit
#, it will look through the list and output the current PW and then th
new one. In that process, it will change CurrentPW in the list to it
NextPW value, and change NextPW to whatever is supposed to be next o
the list. I'm sure you get the idea. Thanks for any help