Hello Friends
i have 4-5 worksheets which contain a number of workbooks (all the workbooks contain data in the same format),
What i want to achieve is i want all the data from all the worksheets into a new workbook.
How would i go about it....My problem is i want to automate this task so that the client can get the desired output in one single click
Please help me out
Configuration: Windows XP Internet Explorer 7.0
"excel.sheet" style number format Combine data of excel sheet in one sheet Compare cell by cell and copy data in excel Conversion from billion to rupees in excel sheet Converting data in excel sheet by c# Copying one sheet data to other sheets in excel vba Excel data import "from multiple excel files" Excel help on automatically copying data from one sheet to another only if the cells has specified data Find and replace vba multiple excel How to compare 2 excel sheets with find function How to compare two excel sheets with unique id How to filter data in excel Import data from notepad to database Import data from one excel file to the other vba Import data into excel multiple sheets in windows applications Import data into excel multiple sheets in windows forms Import data into multiple worksheets Vba multiple excel sheets to one postscript file