Hi!
I would be pleased to do a project for you again! I can deliver very fast, I have the scripts ready, only have to complete it if you could please answer a couple of questions I have after going through your requirements:
1. Done: are there also subfolders? (If yes: if masterfile is in "C:\SomeFolder\ and path of file in subfolder would be: C:\SomeFolder\SubFolder\, what would you like to put as filename? Only the filename, or also the name of the subfolder?)
2. I will not only ignore "CombinedData", but also the "temporary filenames", e.g. if "[login to view URL]" is open, there is also a temporary filename "~$[login to view URL]".
3. Button on Sheet2 = OK
4+5+6+7+8 = OK
9. What do you mean by copy color highlight? Copy value including formatting (including cell color) = OK
10. If e.g. a cell is bold + red, and bold comes from straight forward formatting and red comes from data validation rule: do you want to copy "bold + red" (= not the [login to view URL] but the [login to view URL]) or only "bold" (= neither the formatting rule nor the formatting value)
Many thanks again for your consideration and I look forward to working on this project!
I will also send you a message in your inbox to make sure you won't miss my bid between the many other ones...
Brgds,
MKL7