Results 1 to 7 of 7

Copy & Paste Row 3 from multiple worksheets to summary sheet if cell A3 equals a date

Threaded View

  1. #1
    Registered User
    Join Date
    12-27-2014
    Location
    Oregon, USA
    MS-Off Ver
    2007 and 2013
    Posts
    4

    Copy & Paste Row 3 from multiple worksheets to summary sheet if cell A3 equals a date

    I'm helping a food bank move from paper to Excel. There are multiple worksheets with information about households on each sheet and they need to do a summary report every month and for just that month. Row 3 on each sheet contains all the data required. I found the following code to copy all row 3's but I have not been able to figure out how to filter for a date, which is in Cell "A3". Adding Subtotals at the bottom would be a major plus. I Know I can use the Filter for dates but most of the volunteers are not very computer savvy so I am thinking a button that does it all would be ideal. Your help will be greatly appreciated. Thank you.

    Private Sub CommandButton1_Click()
    ' FoodPantry
    Dim ws As Worksheet, nr As Long
    For Each ws In ThisWorkbook.Worksheets
      If ws.Name <> "Summary" Then
        nr = Sheets("Summary").Range("A" & Rows.Count).End(xlUp).Offset(1).Row
        ws.Rows(3).Copy Sheets("Summary").Rows(nr)
      End If
    Next ws
    End Sub
    Last edited by FDibbins; 12-29-2014 at 04:18 PM. Reason: code tags added

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] copy data from multiple worksheets and paste into summary sheet
    By forquaidian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2014, 08:27 AM
  2. Copy and paste the most recent entered data from other worksheets to summary sheet
    By cvsrini in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2013, 04:51 AM
  3. [SOLVED] Copy multiple worksheets data & paste into blank columns in summary worksheet
    By guest99999 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-21-2013, 09:56 AM
  4. [SOLVED] Summary sheet - copy cell contents from multiple sheets to one summary sheet
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 10:32 AM
  5. Search multiple worksheets, copy and paste into "Summary" sheet
    By meowzers in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2010, 05:06 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