![]() |
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