largeselection
Active Member
- Joined
- Aug 4, 2008
- Messages
- 358
Hi,
I've done a little bit with macros that run on changes within a cell (checkmarks and such).
I'm trying to have one that basically executes a find based on the cell value that changes. As it stands now I have a sheet conditionally formatted so that when I put in an ID number in cell B17 it will highlight the entire row where the value in B17 is equal to the value in the cell in column A.
What I'd ultimately like to have happen is for it to execute a find and "jump" to that location. So I'd like to be able to type in ID# 1 into B17 and then have it automatically jump to that row (which will be highlighted yellow).
Sorry if this is confusing please let me know if you have any questions! THANKS!
I've done a little bit with macros that run on changes within a cell (checkmarks and such).
I'm trying to have one that basically executes a find based on the cell value that changes. As it stands now I have a sheet conditionally formatted so that when I put in an ID number in cell B17 it will highlight the entire row where the value in B17 is equal to the value in the cell in column A.
What I'd ultimately like to have happen is for it to execute a find and "jump" to that location. So I'd like to be able to type in ID# 1 into B17 and then have it automatically jump to that row (which will be highlighted yellow).
Sorry if this is confusing please let me know if you have any questions! THANKS!