Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I determine the modification date of a cell? robrowe Excel Worksheet Functions 3 February 9th 09 06:00 PM
Prevent Cell modification when Excel is executed Paul Worsnop Excel Discussion (Misc queries) 2 November 11th 08 04:19 PM
Automating entry in a cell BrownsFan Excel Worksheet Functions 2 August 11th 06 03:55 PM
Automating text in a cell Jock W Excel Worksheet Functions 2 March 24th 06 02:06 PM
Automating Excel Cell Drag and Drop Greg Wilson[_3_] Excel Programming 0 August 22nd 03 04:24 AM


All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"