Next question, I have two columns a Qty column (K) and a Units column (L). If the product is sold by the case then both numbers are the same but if the numbers are different then I want to delete the Units cell in the Units column.
Next question, I have two columns a Qty column (K) and a Units column (L). If the product is sold by the case then both numbers are the same but if the numbers are different then I want to delete the Units cell in the Units column.
Looks fairly straightforward. Have you tried making up your own code for this?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thats scary. I haven't taken off my training wheels yet!!!!
if you plug away at it, before you realize it you won't need much help
but that means I must think, and that hurts the brain. lol
Yes, maybe. But people are here to help each other, not to do your job instead of you. You could do that pretty easily if you tried I guess. And if you really have a problem, then ask; but not before you even tried.
Jungix,
First, No need to be rude! Haven't you ever heard of a joke????
Second, I am just starting to write code. I used to get all my code from the Macro Recorder!!!!!
Daniel
Sorry I didn't want to sound rude. I am also starting VBA. If you never try to write macros yourself you will never improve, and you'll need to do it yourself one day anyway, so the sooner the better ^^