a hard (impossible) one - catching data and locking it without VBA

[yoniman]

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!!!!

[Ace_XL]

Cannot be done wothout VBA

Please Login or Register  to view this content.

This will input date in Col B when Col A is changed

[yoniman]

Sure Ace_XL
but this is what I said that I'm trying to avoid VBA as when I share the file it might cause issues if the security is not defined properly.

any formula idea?

[ChemistB]

As per Ace, "It cannot be done without VBA"

[yoniman]

that is what I suspected.
thanks for trying and have a great weekend!