Hi everyone,

I'm trying to create a macro which will allow me to select any cells on the data sheet and paste a variable-sized copy of only values and transpose it. The copied cells may or may not be recorded on the same workbook. I've been researching online and haven't been able to find one that works with the above scenario. I'm hoping to have the macro attached to CTRL-S. Any suggestions from the gurus?

Thanks everyone