I found this macro on the Net and modified it for my purpose. I am really really new at writing/modifing VBA. The macro works, but each file has a different number of rows.
I need the macro to copy all data starting with A14 to F14 down to last none empty row (example: A14:F26 or in another...