Hi, i have this code below but im trying to figure out where if any cell in the same row from column E to F is > 0 then add a date to column A. If nothing in E to F then blank in column A. Currently its only working for column E and if i delete the value in column E, the date still stays there. I want it to be removed. Thanks.
Please Login or Register to view this content.
To make it work for column F as well, adjust this part:
Please Login or Register to view this content.
Thanks Yay, that worked but now if i delete the value those columns the dates still there. anyway where those dates can be removed if i delete those values in the columns?Originally Posted by yay_excel
To make it work for column F as well, adjust this part:
Please Login or Register to view this content.
Last edited by biznez; 05-27-2015 at 04:16 PM.
Please Login or Register to view this content.
thx yay_excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks