Auto copy/paste from one spreadsheet to another every hour pasting into the next column

[[email protected]]

Good Day All,
I've linked excel to a PLC pulse and download columns of data and these columns are updated live. I would like to copy the data in these columns every hour and paste values only into another spreadsheet for analysis. This will have to continue ongoing. Any help would be great! I have not started the code so I have nothing to offer you as far as a start. Again thank all for looking.

Moderator's note: Moved from "Tips and Tutorials"--6StringJazzer

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic