ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automating Modification of a Cell Link (https://www.excelbanter.com/excel-programming/322947-automating-modification-cell-link.html)

pep819

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?


All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com