Results 1 to 34 of 34

Extract from multiple worksheets based on one condition and output to new workbook

Threaded View

Lifeseeker Extract from multiple... 12-21-2011, 06:59 PM
arlu1201 Re: Extract from multiple... 12-22-2011, 06:10 AM
Lifeseeker Re: Extract from multiple... 12-22-2011, 01:59 PM
Lifeseeker Re: Extract from multiple... 12-23-2011, 12:53 AM
arlu1201 Re: Extract from multiple... 12-31-2011, 09:11 AM
Lifeseeker Re: Extract from multiple... 12-31-2011, 01:27 PM
arlu1201 Re: Extract from multiple... 01-08-2012, 11:09 AM
Lifeseeker Re: Extract from multiple... 01-08-2012, 02:17 PM
arlu1201 Re: Extract from multiple... 01-08-2012, 02:26 PM
Lifeseeker Re: Extract from multiple... 01-08-2012, 02:38 PM
arlu1201 Re: Extract from multiple... 01-08-2012, 03:21 PM
Lifeseeker Re: Extract from multiple... 01-09-2012, 03:21 PM
arlu1201 Re: Extract from multiple... 01-09-2012, 03:29 PM
Lifeseeker Re: Extract from multiple... 01-09-2012, 03:48 PM
Lifeseeker Re: Extract from multiple... 01-10-2012, 02:13 AM
Lifeseeker Re: Extract from multiple... 01-10-2012, 02:49 AM
arlu1201 Re: Extract from multiple... 01-10-2012, 04:16 AM
Lifeseeker Re: Extract from multiple... 01-10-2012, 10:31 PM
Lifeseeker Re: Extract from multiple... 01-13-2012, 02:48 AM
Lifeseeker Re: Extract from multiple... 01-13-2012, 04:12 AM
arlu1201 Re: Extract from multiple... 01-13-2012, 04:20 AM
arlu1201 Re: Extract from multiple... 01-13-2012, 04:59 AM
Lifeseeker Re: Extract from multiple... 01-19-2012, 01:25 PM
Lifeseeker Re: Extract from multiple... 01-20-2012, 08:24 PM
arlu1201 Re: Extract from multiple... 01-21-2012, 01:16 PM
Lifeseeker Re: Extract from multiple... 01-22-2012, 05:31 AM
arlu1201 Re: Extract from multiple... 01-22-2012, 07:14 AM
Lifeseeker Re: Extract from multiple... 01-23-2012, 02:14 AM
arlu1201 Re: Extract from multiple... 01-22-2012, 07:11 AM
arlu1201 Re: Extract from multiple... 01-23-2012, 11:04 AM
Lifeseeker Re: Extract from multiple... 01-23-2012, 03:25 PM
arlu1201 Re: Extract from multiple... 01-23-2012, 03:52 PM
Lifeseeker Re: Extract from multiple... 01-23-2012, 05:02 PM
Lifeseeker Re: Extract from multiple... 01-23-2012, 05:05 PM
  1. #1
    Valued Forum Contributor
    Join Date
    10-21-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    513

    Extract from multiple worksheets based on one condition and output to new workbook

    Hello,

    I am trying to create a button that generates 3 reports based on one condition. Please see the attached file.

    There are 3 tables to be generated, namely, worksheet A, B and C.

    In worksheet A, there is a master button, "Generate quarter report". I would like to first select a specific quarter(Q 1, Q 2, Q 3 or Q 4) from the dropdown list in cell D2, and hit that master button. The purpose of the button is to filter all of the records from three worksheets based on that quarter selection and output the 3 worksheet recordsets to a new workbook.

    Additionally, I would like the new workbook to be able to prevent users from modifying records in the output files by default. (simply just want to have columns locked)

    Is this possible?

    Thank you
    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