Copy From Different files to one file

[pvsvprasad]

Dear Masters,

I need one code for Copy from different files (Including Current file Name "Test4" Sheet No.1 Range) to Current file Sheet No.2 as below Procedure:

*Run the Code at Current file name Test4

*Open pop up box for Selecting Files (Ex:File names like Test1, Test2, Test3)

*Select required Files at once,then press OK button.

*automatically copy from specified file name and data range i.e Current file (File name is Test4) and and range is "F3 to H4" range data to Sheet.2 of current file specified Range Ex: A6 to B7,

*Copy from Already Selected files (Data read from specified file names order, Ex: File names like Test1, Test2, Test3

*automatically copy from Already selected file name and data range i.e File name is "Test1" and and range is Sheet.1, "G3 to H4" range data to Sheet.2 of current file specified Range Ex: A6 to B7,

*automatically copy from specified file name and data range i.e File name is "Test2" and and range is Sheet.1, "F3 to G4" range data to Sheet.2 of current file specified Range Ex: A8 to B9,

*automatically copy from specified file name and data range i.e File name is "Test3" and and range is Sheet.1, "K3 to J4" range data to Sheet.2 of current file specified Range Ex: A10 to B11.

Please prepare suitable code as mentioned range and file names.


Thanking you,
Best regards.

[davesexcel]

Find loop through folders
http://www.xlorate.com/vba-examples....rough%20Folder
https://www.youtube.com/watch?v=6XsvI9i2z7s

[pvsvprasad]

Find loop through folders
http://www.xlorate.com/vba-examples....rough%20Folder
https://www.youtube.com/watch?v=6XsvI9i2z7s

Thank you for your kind reply,

i dont know about Programming, i need help from anyone.

kindly help me and make a suitable code.

Thanking you,
Best regards.

[davesexcel]

You can look at the links I sent you and there are several other examples on the web to look at, even this forum has a lot of threads about it.

Try to do something yourself, then when you run into problems, come to the forum and ask for help.

[pvsvprasad]

You can look at the links I sent you and there are several other examples on the web to look at, even this forum has a lot of threads about it.

Try to do something yourself, then when you run into problems, come to the forum and ask for help.

Dear sir,

thank you for your kind support and i cannot understand code language. i look forward for replies from other Masters of this forum.


Thanking you sir,
Best regards.

[pvsvprasad]

Kindly help me any master.

Thanks in advance,
Best regards.

[pvsvprasad]

Kindly help me any master.

Thanks in advance,

Best regards.

[davesexcel]

You haven't given anything that requires help, you just want somebody to do it for you.

[pvsvprasad]

Dear Masters,
I am trying to modify Below code. but not successful.my file types are xlsx or xlsm, please make suitable corrections.

Please Login or Register  to view this content.

Thanking you all,
Best regards.