I found the solution myself searching the forums...
http://www.excelforum.com/excel-prog...o-another.html
link to the solution above, Im all good.
______________________________________________________________________________________________________________________
This macros seems pretty simple, Im just not sure how to check if the row it is being pasted into is empty and how to choose the next one.
In the excel file ive attached I want to take the data in "Input" sheet ranged Y2:AE2 (data is a formula), I want to then copy the data over to the "Database" sheet and have the values pasted as VALUE under the heading, as the original data is a formula. I want to essentially have the macros check to see if the row it is being copied to is empty and just paste it underneath, essentially creating a database for myself.
Any help would be appreciated,
Thank you
Bookmarks