If there is anything in E4, I need to delete the contents of D4,
and I need this to happen to all the other cells below it also, so if there is contents in E5 need to delete the contents of D5,
all the way to E15 and D15,
I should mention that these rows are in a table, if it makes a difference.
thanks
Is D4:D15 hard values, or a formula?
Just a user entered value
Ok, how about
Please Login or Register to view this content.
That did not work as expected,
Any where I click, the cells in D5:D15 get filled in with a date, unless there is something in E5:E15,
What I need to do is treat every row individually,
So if there is anything in E5 Delete the data in D5
So if there is anything in E6 Delete the data in D6
So if there is anything in E7 Delete the data in D7
and so on..
Last edited by new guy; 02-09-2020 at 02:24 PM.
Ok, how aboutWhenever you change a cell in E4:E15 it will clear col D for that row if E has a valuePlease Login or Register to view this content.
Thank you!!
That works perfectly.
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks