Hi,

1) i have extract different excel report in one folder now i have to arrange all the extract report data in one sheet with same format and one by one. ex. suppose 1st sheet data end on row 10 then then 2nd data paste just below on that and same for 3rd,4th etc. And i have to copy all the data in that sheet not particular column & rows.

Can anyone help for the above query...

Thanks in advance