Copy and paste multiple excel files
I have about 5 files that are the same but will be updated by different users everyday. I would like to have a master file that will copy all the information beginning in row 6 down to the first empty row from each of the 5 files. Then I would like for it to paste in the master one after another. I know how to code this procedure with a set number of rows but not when each file length will vary. Can someone please help. A copy of a screen print from excel is attached.
Reply With Quote