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
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