Results 1 to 7 of 7

Extract and summarize from 100 worksheets into one

Threaded View

HMIExcel08 Extract and summarize from... 06-18-2008, 01:16 PM
Trebor76 Hi Amy, Using the code... 06-19-2008, 01:18 AM
HMIExcel08 Re: Extract and summarize... 06-19-2008, 12:31 PM
Trebor76 Hi Amy, Thanks for the... 06-19-2008, 07:17 PM
HMIExcel08 Re: 06-19-2008, 11:07 PM
  1. #1
    Registered User
    Join Date
    03-11-2008
    Posts
    27

    Extract and summarize from 100 worksheets into one

    Hi All,

    Please see attached Excel sample file. I would like to extract information with the event “Date” happens in June(6/1/08-6/30/08) in Column B on each worksheet. And I would like these data to be summarized from all different worksheets into one. Is there any code I can use so that I can drag these information out into a single worksheet at one time instead of keep looking in each worksheet (about 100) doing copy and paste?

    Please be advised.

    I appreciate for all your time and help!

    Amy
    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