Results 1 to 13 of 13

Generating summary sheet from excel form

Threaded View

  1. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Generating summary sheet from excel form

    I changed the workbook event to manual running of code... Please click the button which is there in the summary sheet to get data from all sheets, except the first 3 sheets (Including the hidden sheet).

    Sub GetDataFromAllSheets()
    Dim Sh As Worksheet, sConc As String, iWsNo As Integer, sBase As String
    
    sBase = "SUMMARY"
    
    For Each Sh In ThisWorkbook.Sheets
        iWsNo = Sh.Index
        If iWsNo > 3 Then
            With Sh
                sConc = .Range("C8") & " " & .Range("C10") & " " & .Range("C12") & _
                    " " & .Range("C14") & " " & .Range("C16") & " " & .Range("C18") & _
                    " " & .Range("C20") & " " & .Range("C23") & " " & .Range("C25") & _
                    " " & .Range("C27") & " " & .Range("C34") & " " & .Range("C36") & _
                    " " & .Range("C38")
            End With
            With Sheets(sBase)
                .Cells(iWsNo, "A").Value = Sh.Range("B1").Value  'Last Name
                .Cells(iWsNo, "B").Value = Sh.Range("G1").Value  'First Name
                .Cells(iWsNo, "C").Value = Sh.Range("B3").Value  'Division
                .Cells(iWsNo, "D").Value = sConc 'Desc
                .Cells(iWsNo, "E").Value = Sh.Range("C28").Value 'Total Hours
            End With
        End If
    Next Sh
    
    End Sub
    Refer the attached file for details
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1