Dear All,
I have this excel whereby the rows and columns have quite a length of data.
Example:
My row 1 consist of product code.
I wonder if there is any macro or a method to fullfill my request below:
Lets say I am currently at Column AA Row 2223, I wish to jump to the column AD but maintain at Row 2223.
How I did it, is highlight the whole Row 1, and CTRL F the product code, but this will trigger excel to jump straight back to Row 1 due to my search result, this is very inconvenient cause I need to scroll all the way back to Row 2223.
Hope there is anyone out there would be able to provide advise/help to my little inconvenience.
Thanks and regards,
CU
I have this excel whereby the rows and columns have quite a length of data.
Example:
column AA | column AB | column AC | column AD | |
Row 1 | AA50 | AA51 | AA52 | AA53 |
Row 2223 |
My row 1 consist of product code.
I wonder if there is any macro or a method to fullfill my request below:
Lets say I am currently at Column AA Row 2223, I wish to jump to the column AD but maintain at Row 2223.
How I did it, is highlight the whole Row 1, and CTRL F the product code, but this will trigger excel to jump straight back to Row 1 due to my search result, this is very inconvenient cause I need to scroll all the way back to Row 2223.
Hope there is anyone out there would be able to provide advise/help to my little inconvenience.
Thanks and regards,
CU