Automating Modification of a Cell Link
I have a list of employees on one sheet and want to display the data about
each in another sheet. During this display, I'd like to have a macro
<button that would allow me to essentially scroll down the list. So, if
the only link on the second sheet was =Sheet!1A!1, I'd like to run the macro
to change the link to +Sheet!1A!2. Can anyone help?
|