using the print screen to copy - and it wont let me paste in excel to another computer

I'm guessing that each monitor has it's own instance of Excel running. If you open your 'copy from' spreadsheet from within the same instance of Excel that you'll be pasting to, it should work.