You could use SetAttr and GetAttr to set/read an attribute which would flag copied files.
If you are using Office 2003 or earlier, you could use FileSearch and use the file index.
You could use SetAttr and GetAttr to set/read an attribute which would flag copied files.
If you are using Office 2003 or earlier, you could use FileSearch and use the file index.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'