1. Record a macro that does what you want and post it here

2. Attach sample workbooks (Master, supporting, whatever)