This will require VBA

http://www.excelforum.com/excel-form...ther-page.html