Macro help

[Tonyk1051]

I dont have excel on my computer so dropbox is going to have to do, i need a Macro to do the intructions below, thanks

Dropbox - File Deleted - Simplify your life

www.dropbox.com

If coulmn S is yes

and column W says open box put in column H used IF coulmn W says

defective /unspecified or damaged then put in coulmn H

LR if value in column O is $20 or less, put Tradeport if value is between $20-$50

or put TL if value is over $50 BUT if column N has key word "cell phone" or "notebook" put in TT

 

[Michael M]

Does "YES" in Column S apply to all other options in your request ?
AND
Where does "Tradeport","TL" get placed?
IS Column "N" relative to the value in column "O"

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: IF Then ElseIf Else Statement macro
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Michael M]

In that case....I'm out ?