Some more work on a Sporting solution
Require a formula please (no VBA) to copy data from one location to another – triggered by a DataValidation selection.
Copy and Paste Value so formats etc don't get changed
The attached WBook explains in detail.
Bookmarks