[mackinlay]

AJ,

I was just trying to replicate your solution into my full workbook and I was wondering if you can tell me how to hook up the drop-down menu (which I've changed to Yes or No) to start the macro to paste the items in.

I think that I copied the appropriate code accross and have made the alterations where necessary to account for the re-named worksheets.

I'm pulling my hair out here!lol!

Mack.