VBA is not a five minute learn. But what you need is not difficult or complicated.
You would need a Worksheet Change Event handler monitoring the cell(s) withe Data Validation drop down. When you select a value, you execute the formula (in the code) and put the returned value in the target cell.
Post a sample workbook and we can give you the code.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I kind of guessed that, looking into it a little it seems like a bit of a new (but very exciting!) world to me.
Thank you for the explaination!
That would be so very kind. I try to post a sample workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
EmmaLearns 
Register To Reply
Bookmarks