macro to do a search of the text in column A and move 1 step to right for values in Col. B

Hello,

I need help with my excel vba.

In Cell A5 I have "gross profit" and in cell B5 I want to put in a formula where it looks for "sales" and subtracts "expenses" which has the values in column B.

I want the macro to do a search of the text "sales" and "expenses" in column A and move 1 step to right to pick up values in column B.

thanks so much for your help!!!

K

Why do you need VBA? Sounds like a formula might do, maybe SUMIF or SUMIFS.


Please see the yellow banner at the top of the page.

Administrative Note:

Welcome to the forum.

10 is not an Office version (it's Windows) - please update your forum profile with the correct information.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. You are new, so I have done it for you this time.)