I am completely new to Excel macros.If anybody could help me on this..that would be great.Thank you.
I have two different folders
Folder 1:With BOD( worksheets from client which can be in any number)-Format1
Folder 2:Invoice(Single Worksheet where i should group all the details from BOD worksheets)-Format2
Please find the Worksheet formats attached.
Things to do:
1.B3 (Format1) to A12(Format2)
2.J&Q13(Format1) to X12(Format2)
3.A,B,C,D,E,F,G,H,I,J,O,P,S,T,U27(Format1) to B,C,D,E,F,G,H,I,J,K,P,Q,T,U,V12(Format2)
This should happen for each and every row in Format1 and and each format1 in folder 1.
Any ideas would be much appreciated. thank you.
Bookmarks