Macro to copy data from one file to a 2nd file
I am new here but here is the gist of what I need help on.
I have 2 excel files. One will be the Master data holder. The second is the input file.
I want to write a macro that will run from the input excel file that will find the first empty row in the master available and then copy a set of lines from the "input" file into the "master" file.
The help I need is how to open and run using these 2 different files. I already can run the copy commands once I can link the two excel files. I am using the "ActiveSheet.Cells(NUM, 2).Value = Worksheets("IF").Cells(2, 4)" command to copy between sheets. I just need to know the next step of going to a new workbook.
Whatever help is available would be much appreciated.