LearnMeExcel
Well-known Member
- Joined
- Aug 11, 2009
- Messages
- 746
- Office Version
- 365
- 2021
- Platform
- Windows
hi all
i am looking for code to loop throw my files, and if my file name start with "COGS" to copy data from sheets call "Final Estmate" and paste it to my master file which called "COGS From ALL Cities" in sheet called "All COGS"
how i can do that by code?
but please note my files on Network not on my Laptop?
i am looking for code to loop throw my files, and if my file name start with "COGS" to copy data from sheets call "Final Estmate" and paste it to my master file which called "COGS From ALL Cities" in sheet called "All COGS"
how i can do that by code?
but please note my files on Network not on my Laptop?