amaresh achar
Board Regular
- Joined
- Dec 9, 2016
- Messages
- 108
- Office Version
- 365
- Platform
- Windows
Hi,
I have about 3000 files in Folder-A and 6000 files in Folder-B
Folder-A has files with file names like:
PARTNO1.xlsm
PARTNO2.xlsm
PARTNO3.xlsm
PARTNO4.xlsm
PARTNO5.xlsm
PARTNO6.xlsm
.
.
.
PARTNO3000.xlsm
Folder-B has files with file names like:
PARTNO1_SCODE_PROD.xlsm
PARTNO1_SCODE_SAMP.xlsm
PARTNO2_SCODE_PROD.xlsm
PARTNO2_SCODE_SAMP.xlsm
PARTNO3_SCODE_PROD.xlsm
PARTNO3_SCODE_SAMP.xlsm
PARTNO4_SCODE_PROD.xlsm
PARTNO4_SCODE_SAMP.xlsm
PARTNO5_SCODE_PROD.xlsm
PARTNO5_SCODE_SAMP.xlsm
PARTNO6_SCODE_PROD.xlsm
PARTNO6_SCODE_SAMP.xlsm
.
.
.
PARTNO3000_SCODE_PROD.xlsm
PARTNO3000_SCODE_SAMP.xlsm
Each file from Folder-B has a part of its name exactly same as file name in Folder-B.... With that as reference,
In every file of Folder-A, there is a worksheet named "Balloon Drawing"
From Folder-A, From each files, I want to copy that "Balloon Drawing" sheet to the files in Folder-B which contains shares similar file name.
Eg: Folder-A --> PARTNO13.xlsm ("Balloon Drawing" sheet from this file)
Folder-B --> PARTNO13_SCODE_PROD.xlsm (to be copied to this file) and PARTNO13_SCODE_SAMP.xlsm (and this file)
Thanks in Advance....
I have about 3000 files in Folder-A and 6000 files in Folder-B
Folder-A has files with file names like:
PARTNO1.xlsm
PARTNO2.xlsm
PARTNO3.xlsm
PARTNO4.xlsm
PARTNO5.xlsm
PARTNO6.xlsm
.
.
.
PARTNO3000.xlsm
Folder-B has files with file names like:
PARTNO1_SCODE_PROD.xlsm
PARTNO1_SCODE_SAMP.xlsm
PARTNO2_SCODE_PROD.xlsm
PARTNO2_SCODE_SAMP.xlsm
PARTNO3_SCODE_PROD.xlsm
PARTNO3_SCODE_SAMP.xlsm
PARTNO4_SCODE_PROD.xlsm
PARTNO4_SCODE_SAMP.xlsm
PARTNO5_SCODE_PROD.xlsm
PARTNO5_SCODE_SAMP.xlsm
PARTNO6_SCODE_PROD.xlsm
PARTNO6_SCODE_SAMP.xlsm
.
.
.
PARTNO3000_SCODE_PROD.xlsm
PARTNO3000_SCODE_SAMP.xlsm
Each file from Folder-B has a part of its name exactly same as file name in Folder-B.... With that as reference,
In every file of Folder-A, there is a worksheet named "Balloon Drawing"
From Folder-A, From each files, I want to copy that "Balloon Drawing" sheet to the files in Folder-B which contains shares similar file name.
Eg: Folder-A --> PARTNO13.xlsm ("Balloon Drawing" sheet from this file)
Folder-B --> PARTNO13_SCODE_PROD.xlsm (to be copied to this file) and PARTNO13_SCODE_SAMP.xlsm (and this file)
Thanks in Advance....