LinkBack URL
About LinkBacks
Could you please help... with the below?
If C2 = "y", copy A2 into B2, if Y changes into "n" (or any other value including blank), Clear Cell B.
This should apply yo the whole sheet - please find a very basic example attached.
Thank you!
Could you please help... with the below?
If C2 = "y", copy A2 into B2, if Y changes into "n" (or any other value including blank), Clear Cell B.
This should apply yo the whole sheet - please find a very basic example attached.
Thank you!
Hi,
In B2 and copied down the column
EDIT: Apologies, I've just seen that you want VBA for this.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sweep; 08-25-2017 at 07:37 AM.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Give this a go...Place code in sheet Module.
Please Login or Register to view this content.
Last edited by Sintek; 08-25-2017 at 07:41 AM. Reason: changed code for entire C column
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Glad I could contribute...seems like sweep and I were on same page simultaneously...
Thanks for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks