(I am currently in the Navy, onboard the USS Stennis)I am
having a problem creating a macro that allows others (who
are not excel smart) to enter a new name. This name
would then be posted on a new worksheet tab along with
the name being entered onto the front page (to be
hyperlinked to its coresponding worksheets (based on the
name)
For example:
The user runs the macro. It prompts the user to enter a
name (say john). The macro then creates
WKSHTS: John, John(1), John(2). and on the home page the
name John is entered to be hyperlinked to the
worksheet "John". (There are at least 40 wkshts) The
problem is I am leaving my command soon. I have done all
of the changes myself w/o macros (i just learned about
them). However, my replacement is not excel smart. I
have tried to explain to him what to do (even tried to
write out the instructions) with no avail. I created
this program and my CO wants to keep it running w/o me.
I thank you very much for your time.