I've made some cross posts here:
http://www.vbaexpress.com/forum/showthread.php?p=284372#post284372

http://www.thecodecage.com/forumz/microsoft-excel-forum/213699-help-needed-finished-visual-basic-applications-code-copy-paste-values-1-min-intervals.html

http://www.mrexcel.com/forum/excel-questions/679814-help-needed-finished-visual-basic-applications-code-copy-paste-values-1-min-intervals.html#post3366918

The only help I've gotten so far is here:
http://www.excelkey.com/forum/viewtopic.php?f=3&t=3032&sid=6acd5c5ef7689bfa03c25982a6c78396&p=10736#p1073 6

This link above has my new code, as well as an explanationof the problems I've been having. You can also download the spreadsheet to seeit for yourself.

Terribly sorry for the cross posts, it wont let me delete the post, so I'm stuck having to ask for help at risk of being banned or being ignored.