LinkBack URL
About LinkBacks
Hi,
Please see attached.
In column M of sheet "Data" I would like a macro to print the word "New" if the
value for "days opened" in column L is "0". Eg. Column M2 and Column M9 should have the values
"New".
Thanks in advance
Print word based on value of column
Hi,
Please see attached.
In column M of sheet "Data" I would like a macro to print the word "New" if the
value for "days opened" in column L is "0". Eg. Column M2 and Column M9 should have the values
"New".
Thanks in advance
Hi there,
You don't need a macro, just put this formula...
=IF(L2=0,"New","")
...into cell M2 and fill down to M9.
HTH
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hey Trebor76,
It works =] Thanks for you help
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks