polugopi87
Member
I have 1 folder contains 5 excel files. Each excel contains data in two sheets let's say sheet 1 and sheet 2 .
how can i add all excel file's sheet 1 data in to new excel file Sheet 1 and all excel files's sheet 2 data into new excel file sheet 2 .
can any one please provide solution ?
i am stucked in this stage. if any one suggest the solution then it will be helpful to me.
how can i add all excel file's sheet 1 data in to new excel file Sheet 1 and all excel files's sheet 2 data into new excel file sheet 2 .
can any one please provide solution ?
i am stucked in this stage. if any one suggest the solution then it will be helpful to me.