Forum Discussion
GOTO a specific cell, based on another cell's data
I have a spreadsheet where I would like to move to a specific column, based on the data entered. For example: In A1, I enter a name: Joe If Joe is entered, I want to go directly to column J in th...
Als Makro kann ich Ihnen das anbieten:
sub jump()
if Range ("A1"). value <> "Joe" then Range ("J1"). select
end sub
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.