View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pep819 pep819 is offline
external usenet poster
 
Posts: 1
Default 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?