Find and transpose adjacent values
Need code that does the following when run:
List of dates start in a1:a300
In a1: "12/31/09"
Adjacent Names in b1"larry", c1"curly", d1"moe"
Dates in E1:N65 (range name "calendar")
When code is run...
If date in a1 is found in named range, paste & transpose values under
date.
ie. if date in a1 is found in E20,
paste values "larry" in e21
paste values "curly" in e22
paste values "moe" in e23
|