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!
Try this code [code] Private Sub CommandButton1_Click() 'Variable Declaration Dim iCnt As Integer, i As Long, j As Long, shdr...
I need to group rows based on repeated text cell in column A , no. of columns are dynamic
then sum total of each group and hide the groups showing only the totals
As start point try this code
Dim AsteriskPositions(1 To 1500) As Long
Dim counter As Long, I As Long
For I = 1 To Range("A" & Rows.Count).End(xlUp).Row
If Cells(I, 1).Value <> Cells(I + 1, 1).Value Then
counter = counter + 1
AsteriskPositions(counter) = Cells(I, 1).Row
For I = 1 To counter
If I = counter Then
Range("A" & AsteriskPositions(I) + 1 & ":A" & AsteriskPositions(I + 1) - 1).Rows.Group
Can you show us sample of your workbook to see what we can do with totals?
Thanks for the assistance, tried with above code, its grouping only for few texts not for all the unique texts in Column A, there are more than 3000 rows, month on month it keeps increasing.
Also let me know where to send the sample workbook attachments??? any email ID??