Combine Workbooks

[Rahulwork]

Hello Everyone,

i am working on a project and bit new on macro area

need to do some amendment in workbook saved in folder. please find below

I have an excel where i have button. now

in A1 there is path of folder and in B1 i have file name Test1.xlsx and in B2 Test2.xlsx (only one sheet would be there)

both the excel files has same header. so want when i click on button macro would
- open Test1.xlsx and Test2.xlsx and
- copy Test2.xlsx data from C3 to last filed column and row
- paste to the Test1.xlsx last filled row. and save and close both the file
- create a new folder named Consolidated
- copy test1.xlsx into that folder and rename as consolidated test


I know it's possible via code. please help me. its soo urgent

 

[Joe4]

Have you tried using the Macro Recorder?
You can get a lot of the code you need just by turning on the Macro Recorder and performing these steps manually.
When you are done, stop the Macro Recorder and view your code.

You may need to do a little clean-up of the code afterwards to make it a little more concise and dynamic, but this will give you much of the code that you need.

Note, that if your data is continuous, you can get to the end of the data by going to cell C3, then selecting CTRL+SHIFT+*. This selects the Current Region (see: CurrentRegion Property in Excel VBA).

If you still need help cleaning up your code when you have finished doing this, just post back to the ticket with your code and explanation of what still needs to be done.