This is the answer ( I had to answer my own question) Sub CopySheet_NewWorkbook() Sheets(Array("Sheet1", "Shhet2")).Copy End Sub
Please check the following link: http://vbaf1.com/q/a/compile-all-the-3-excel-sheet-data-in-one-sheet-in-new-excel-file/ Here is the sample project: http://analysistabs.com/vba-code/excel-projects/consolidate-data-from-multiple-worksheets-row/ Also, please check the other topic answered...
I think you should add a line to sort the first column first before you group. Try sorting the column...
Thanks for the reply and ur time :) I found the answer to this :)
Hi Amoljagdale, Please try to answer our forum questions. You will be having different type of questions. Its very good...
Hi, Please share your sample workbook at firstname.lastname@example.org Thanks!
let us know the Specific sentence.
HI, Can you share your VBA code? l Thanks!
Hi guys, I have a macro code that opens up excel files and adds them up to an existing workbook …