Results 1 to 12 of 12

Generate a pending list from multiple sheets

Threaded View

  1. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Generate a pending list from multiple sheets

    Try this code......For detail pls see the attached sheet.
    Sub pendinglist()
    Dim ws As Worksheet
    Dim rng As Range, cell As Range
    Dim lr As Long, lr1 As Long
    Application.ScreenUpdating = False
    lr1 = Sheets("Pending").Cells(Rows.Count, 1).End(xlUp).Row + 1
    Sheets("Pending").Range("A4:A" & lr1).EntireRow.Clear
    For Each ws In Worksheets
        If ws.Name <> "Pending" Then
            lr = ws.Cells(Rows.Count, 1).End(xlUp).Row
            Set rng = ws.Range("A4:A" & lr)
            For Each cell In rng
                If cell.Offset(0, 13).Value = "" Then
                    lr1 = Sheets("Pending").Cells(Rows.Count, 1).End(xlUp).Row + 1
                    ws.Activate
                    ws.Range(Cells(cell.Row, 1), Cells(cell.Row, 18)).Copy Sheets("Pending").Range("A" & lr1)
                End If
            Next cell
        End If
    Next ws
    Sheets("Pending").Activate
    Application.ScreenUpdating = True
    End Sub
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create a validation list in E2 pending on D2
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2013, 08:26 PM
  2. Replies: 5
    Last Post: 09-30-2012, 07:47 AM
  3. Replies: 2
    Last Post: 02-06-2010, 11:58 AM
  4. Need a VB code to generate sheets from a list of cells
    By Thanatos in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-07-2008, 08:14 AM
  5. Excel Generate List from Multiple Sheets
    By Scorpio in forum Excel General
    Replies: 5
    Last Post: 05-16-2008, 01:20 PM

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