How to combine 6 different file(but same format) become one

[jackal_yap]

Any good sugestion?
thnks!!!:dunno

[Bob Phillips]

Open each one, get the data, copy it to one one, and close them all.

[jackal_yap]

any

[jackal_yap]

i want one!
is that write the VBA program then it will combine by auto!
any idea?

[jackal_yap]

help!

[Bob Phillips]

You've got to help yourself, try what I suggested, and post back with specific problems. We are not a free service provider.

[Aussiebear]

i want one!
is that write the VBA program then it will combine by auto!
any idea?

jackal_yap, do you always request assistance in this manner?

As XLD has kindly suggested, you need to show some evidence that you have tried to overcome this issue that you are referring to. What have you done to date?

One method of doing so, is to turn your macro recorder on and then copy each file into your master, save the master then stop the recorder.

Then go to the macro and have a look at the code it produced. Its highly probable that the code can be made more efficient, and we might be in a position to assist you in this matter, once you have done this.

Statements, such as "I want one!"..... will normally cause people operating here on the forum to simply bypass your request for assistance. Please consider that everyone here does so in a voluntary basis, and as such, are entitled to respect.

[jackal_yap]

i am sorry....
because now i in the training with no one can teach me VBA!
at the same time i need to write a program using excel macro and i never learn the VBA before that make me crazy.......
but now i solve the problem.
thanks...

[Aussiebear]

That's great to hear that you've been able to solve the issue. Would you care to share the solution with us?

[jackal_yap]

hihi!!
1st i set up the fixed format for the sheet and use macro to set the normal copy and paste on the macro(with the specific area)there then send to out.
after i received i just run the macro!!!
hihi i english is not very good!!!

[jackal_yap]

can i have the website of teaching VBA Excel Macro for newbie

[aaupg2323g]

Hi

Here is the Excel file with vba codes to combine any number of files of same format and saved in a particular folder. Please unzip; save all the files to the sub directory; and then run the macro in the excel.

Hope this helps

Tks
Gary

[Aussiebear]

can i have the website of teaching VBA Excel Macro for newbie

You can get training here. Click on Site Links and select Training.

[jackal_yap]

thanks