Hi
What i am trying to do is i have a cell C4. This is where i am going to input a number. These numbers reside on a column B. They also reside on another sheet in the workbookWhat i want to do is when i enter a number into C4 it will automatically go find the row this number is on, on another. Any ideas?
I want to find a value on the current sheet and once entered in it links you to it on another sheet! A macro!
Cheers thanks!
What i am trying to do is i have a cell C4. This is where i am going to input a number. These numbers reside on a column B. They also reside on another sheet in the workbookWhat i want to do is when i enter a number into C4 it will automatically go find the row this number is on, on another. Any ideas?
I want to find a value on the current sheet and once entered in it links you to it on another sheet! A macro!
Cheers thanks!