It would be the only Excel in a folder named Extracts. Once I have completed all the forumas and Macros in the Excel when I give it to the person who will be in charge of it I plan on having his create a folder on his desktop for the extracts which has a different name each time. These extract...
I have one workbook of changing name but located in specific folder (Extract) where from 'sheet1' I need to copy range $A$1:$M? (don't now last row as it is greater each time) and paste in a workbook 'NAMED' sheet 'data'
If you can point me the right direction I would appreciate it! I think I...