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 email@example.com Thanks!
let us know the Specific sentence.
HI, Can you share your VBA code? l Thanks!
I used to fill the dates for a “database” with STD text boxes. How can I change it to comboboxes?
I would like to integrate a combobox (or else) to change for a more userfriendly way to upload our quotes to a database.
The quote database would connected to a Customer database on another sheet, where I would like to use only two datas, the customer name and the contact person.
I would like to add a drop down box for the company and afterwards the next drop down box should only contain the contact persons for only that company.
Thanks to help!
Could you please explain your query with sample data?