Cant see why this code is doing what it is doing - need expert eyes

Hi Guys,

so this code below specifically tells excel that when you click in column G and a "u: appears, AND column J has an "x" in it - then vba copies the info in column B to a different worksheet (business review). now this works perfectly - however - whenever i click in Column B, the info in COlumn B automatically goes to the Business Review sheet also......i have gone through this too many times and have gone crosseyed trying to work out what is going wrong.

if ANYONE can shed some light please let me know what is written wrong here.

full code below - and highlighted code (bold) specifcally showing what i am talking about above

Please Login or Register  to view this content.

Hoo-Boy got a nested one here. So I ran the code in question (immediate code below) on a test workbook and it worked just fine. In others words double clicking column B did not trigger it but double clicking column G did (as I believe it is supposed to) so I don't think that is your problem:

Please Login or Register  to view this content.

I then went through your supplied code and tracked down the If/End if's. If my count is correct you actually have an extra End If. That may or may not be causing the problem. See attached code with counts:

Please Login or Register  to view this content.

I then went through and tried to condense / insert a few select case where appropriate to try to break up the monotony. Try the code and see if it works for you:

Please Login or Register  to view this content.

hey stynkynts - tried this and got error messages.. i am going to insert the entire code that is written for the page as maybe that is why - see below

Please Login or Register  to view this content.