LinkBack URL
About LinkBacks
hi.
Im just wondering if a cell (L9) content can be removed if anything or a date that is inserted into cell (O9)? This will be the same for all the other rows in these two columns.
Any help would be appreciated
hi.
Im just wondering if a cell (L9) content can be removed if anything or a date that is inserted into cell (O9)? This will be the same for all the other rows in these two columns.
Any help would be appreciated
Check attached....
The macro runs automatically when cell value changes in column O.
The macro looks if there is any value in column O, if column O has any value then then the corresponding value from column L will be removed....
Hope this helps!!
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Hi Thanks for replying.
Nothing works on the sheet you have attached? I have also looked at the code and cannot see anything....could you copy and past the macro on here at all?
Maybe:
Please Login or Register to view this content.
Hi John,Originally Posted by JOHN H. DAVIS
I tried using the basis of your code you gave me the other week where another cells content removes another but for some reason this code is not working for these cells. I don't understand why it does not work :S I have been given another macro where you have to run it to remove but there would be room for error if employees do not run it as i was hoping it could be done automatically like the code from last week
Can you post a sample file in which it does not work? Then I can test and see what's going on.
Please see attached
I am sorry, by mistake I attached the xlsx file...
Seems to work for me? What's not working for you. Note you changed the Columns.Please see attached
Hi John,
The previous one yes I asked for anything in column R to wipe out The contents in Column F (which works fine) I need the same method for Anything in Column O to knock out the contents of Column L swell :S
Did you check mine??
Try:
Please Login or Register to view this content.
Hi Yes i did...it works fine on your sheet but i cannot seem to get it to work on my main template sheet :S......not sure if something is conflicting it......apologies for not seeing your post earlier
Thats the one!! works a treat. Thanks again John and sourabhg98 for all your help
You're welcome. Glad to help out and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks