justmeok
New Member
- Joined
- Jul 27, 2011
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
Hi Excel Gurus,
I'm looking for a solution to the above. I don't mind if it's a formula based solution or VBA (this is the solution I think is most likely). What we want to do is go to a specific column based on the data entered in the Payee Column as per the image below. So if Payee entered is Power Company on pressing enter (or TAB) the cursor would go directly to column headed Utilities on the same row, or if Payee is Supermarket then the cursor would move to the column called Groceries. There will also be some sundry Payees and so if the Payee is not in the specified list then the cursor will go to the column headed other. Currently using Office 365 on windows based pc. Thanks everyone
I'm looking for a solution to the above. I don't mind if it's a formula based solution or VBA (this is the solution I think is most likely). What we want to do is go to a specific column based on the data entered in the Payee Column as per the image below. So if Payee entered is Power Company on pressing enter (or TAB) the cursor would go directly to column headed Utilities on the same row, or if Payee is Supermarket then the cursor would move to the column called Groceries. There will also be some sundry Payees and so if the Payee is not in the specified list then the cursor will go to the column headed other. Currently using Office 365 on windows based pc. Thanks everyone