try this
http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook
On Wed, Jun 29, 2011 at 11:49 PM, sanjaykumar wrote:
> Can anybody help me in putting multiple excel files in a new excel
> file as a new worksheet?
>
> I have
Can anybody help me in putting multiple excel files in a new excel
file as a new worksheet?
I have 7 various files with various reports, I need all these report
files in a new excel file from where I keep them as a row data for my
report.
At present I am manually copying all the files and putting