I tried right clicking within the original spreadsheet, also in the upper left corner that selects the entire sheet and the copy icon on the ribbon (Excel '07) and in all instances there was no 'window' that opened providing a destination choice as you suggest?

Hi markg2,

It requires you to click on the actul sheet tab itself at the bottom left of excel. So in a brand new workbook for example you would right click on "Sheet1" tab at the bottom left of the screen. Make sense?

Ah ha!

Thanks--

Mark