Copy selection from Excel into Putty (need to use SendKeys to simulate <F4>)

I have a selection of cells in a row (A1:A14) that needs to be copied and pasted into PuTTY. After the selection is entered i need to hit <F4>, which will end the process and allow me to go back into the excel sheet, copy the next selectionSample for Excel Forum.xlsx (B1:B14) and continue on in this fashion.

Currently, i copy the cell range in Excel, right click in PuTTY (which pastes the selection) but I have to hit the <F4> key on the keyboard and go back into the Excel to grab the next selection and repeat the process.

I would like to be able to loop through and create macro/code that process for me back and forth between programs.

**Some of our Function keys have alternate shortcut keys (like to Add the Selection you can <F1> or hit the "a" key) but there is no default shortcut/alternate for the End process (aka <F4>). I've tried to create one button but it had disastrous results.

Yes! I copy in Excel - then go over to my PuTTY session - right click the mouse to paste the data - got to my keyboard and hit F4 and/or ENTER (depending on what the rules are for the PuTTY screen I am in) and back to Excel

Originally Posted by Leith Ross

Hello WNErika,

Currently, you are doing everything using cut and paste between the two programs?