Quote Originally Posted by rollis13 View Post
My changes in post #7 refer to your attached files in post #5. Don't you think that before providing a solution I didn't test it ?
If you are using your original file maybe you need to adjust some sheet/range references in the code.
yes, i tried, i changed from sheet 16 to sheet1 but it only picked up info from 1 file and the info was written in row 2 and not in row 7.