All,
I'm creating an Action Item List that once column J is changed to "complete", would move the row to a second sheet. I've found on a post that has the solution I need (see hyperlink below) but I don't know how to tweak it so that it uses column J and is extended for a couple of hundred rows.
Any help would be very much appreciated!!
Regards,
ERhttp://www.excelforum.com/excel-prog...lds-value.html
Bookmarks