Move to a specific column based on the data entry in another column

[justmeok]

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

 

[mumps]

In order to do what you want, we would need a list of Payees with their corresponding column header. Perhaps the easiest way to do this would be to have another sheet with the Payees in column A and the corresponding header in column B. Would this work for you?

 

[justmeok]

Hello mumps
Yes I think that could work for us! I will gather a complete list of payees and how would I send that to you? I am assuming in the final solution we would be able to add any new payees to the list?
Thanks for your offer to help, it's really appreciated.

 

[mumps]

You could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your two sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

 

[justmeok]

Hello mumps
Yes I think that could work for us! I will gather a complete list of payees and how would I send that to you? I am assuming in the final solution we would be able to add any new payees to the list?
Thanks for your offer to help, it's really appreciated.

Hi mumps,

Just wanted to come back and let you know that we have changed the process entirely and no longer need a solution to this post. Many thanks to you though for your offer of help, very much appreciated

 

[mumps]

My pleasure. Glad it worked out.