Hi I need some guidance . I am trying to automatically insert (current) static dates in the cells in column p&q when the cells in columns m&n reach the value of zero. Any help would be appreciated . xls below sheet 2
Hi I need some guidance . I am trying to automatically insert (current) static dates in the cells in column p&q when the cells in columns m&n reach the value of zero. Any help would be appreciated . xls below sheet 2
Last edited by DECROMAX; 04-01-2011 at 12:06 AM.
Right clock the sheet tab, select: View Code then paste this sheet change macro in:
Please Login or Register to view this content.
Ben Van Johnson
Thanks for that I just need you to modify it so instead of using column K for the values I use columns M&N and insert the dates into P&Q.
Thanks
Last edited by DECROMAX; 03-31-2011 at 03:57 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks