Results 1 to 6 of 6

Collect data from multiple sheets into a Summary Sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    Johnson City, TN
    MS-Off Ver
    Excel 2013
    Posts
    12

    Question Collect data from multiple sheets into a Summary Sheet

    I am looking for a macro that will look through 31 sheets and check to see if any information has been placed into cells B7:H25 on those sheets. if there is any information in these cells I need it copied and placed on a summary sheet with the sheet name (represents the date) as well as column A which holds the time. It only needs to pull information if there is data present but data may not necessarily go row to row and may skip. I have a partial macro already added that I found while looking through the forums and have left it in. The summary page I would need to have a button to run the macro as well. If anyone can help me I would be much appreciative.
    Last edited by JBeaucaire; 10-04-2012 at 08:03 PM. Reason: Corrected thread title to topic only, as per forum rules

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