Hi Everyone,
I have 8 folders on my desktop namely A, B, C, D, E, F, G & H. Path of these folders are
A: C:\Users\hp\Desktop\Test 1\A
B: C:\Users\hp\Desktop\Test 1\B
C: C:\Users\hp\Desktop\Test 1\C
D: C:\Users\hp\Desktop\Test 1\D
and so on till folder H
In another folder at different location i have 4 excel files namely W, X, Y & Z
file path of these 4 files is : C:\Users\hp\Desktop\Test 2
I am looking for a vba code that will copy file W to folder A and B both
file X to folder C and D both,
file Y to folder E and F both,
file Z to folder G and H both.
Kindly assist me in this.
Thanks a lot in advance.
Bookmarks