Macro? Copy last row from another file to one that is opened

[wickitom]

I am running a program that spits out a excel file (*.csv). The file contains one worksheet with bunch of columns any many rows. I would need to open that file find the last row and copy the data to another excel file and then rerun the program and copy and paste all over.

I am trying to find a macro on the web that will automate this process for me. I don't know anything about creating macros.

I would like a macro or button that whenever I run the macro will copy the last row of data from another file to the one currently active. Whenever I run the macro again, it will copy and paste again into a new row.

I been searching but I couldn't get anything to work.

 

[pboltonchina]

If all your files are in one folder you can use a macro to open each file, copy the data and close the file again. Are all workbooks laid out the same wrt sheet names etc. A bit more info required to help more.