Hi all
I run followup on expenses.
I need to approve receipts on a very long list and to verify I do not pay them twice. Also I wish to know when was each receipt approved for payment (month & year).
Vision - 2 columns. Col-A - validation list 1/0. Col-B - condition of some kind that grabs the date on which A was changed into "1".
Cannot use simple (today()) as that would change all the time.
Any ideas?
I'm open to other concepts but trying to refrain VBA as I share the file with other security settings (already thought of code\macro that copy/pastes as value Col-B with a safety pop-up asks for permission)
thanks all in advance!!!!
Bookmarks