PDA

View Full Version : Delete if same



Djblois
07-19-2006, 11:23 AM
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.

mdmackillop
07-19-2006, 11:36 AM
Looks fairly straightforward. Have you tried making up your own code for this?

Djblois
07-19-2006, 11:43 AM
Thats scary. I haven't taken off my training wheels yet!!!!

compariniaa
07-19-2006, 12:32 PM
if you plug away at it, before you realize it you won't need much help

Djblois
07-19-2006, 01:00 PM
but that means I must think, and that hurts the brain. lol

jungix
07-19-2006, 01:57 PM
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.

Djblois
07-20-2006, 06:39 AM
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

jungix
07-20-2006, 07:33 AM
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 ^^