How can I leave Column "A" blank if any data what so ever is entered in Column "B"?
If coulmn "B" has anything entered in it, Leave column "A" blank
-
-
-
Re: If coulmn "B" has anything entered in it, Leave column "A" blank
Don't enter any information into Col A if the corresponding cell in Col B has data...?
Seriously, do you mean clear Col A when anything is entered into the same row, column B?
-
Re: If coulmn "B" has anything entered in it, Leave column "A" blank
Yes. I have a copy & paste function from one sheet to another. I any data is in Col B I dont want the data pasted in Col A.
-
Re: If coulmn "B" has anything entered in it, Leave column "A" blank
That's slightly different to what's mentioned in your first post...
If you have existing code, then please post it. It may be possible to modify that.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!