Creating a Subset Report

=?Utf-8?B?Qm9i?=

Guest

Posts: n/a

13th Nov 2006

I have a worksheet with 98 columns and over 500 rows. I am looking for an
automated way to create another worksheet (in the same workbook) that has 42
(of the 98) columns and a subset of the 500+ rows, based on certain criteria.
I don’t think creating a PivotTable is the answer here (although I could be
wrong). Can someone point me in the right direction as to how I can solve
this problem (ideally without using 3rd-party tools)? Any help would be
greatly appreciated. Thanks.
Bob

« comboboxes | Multiple selection on a Listbox with checkboxed »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a subset of a Bitmap	Peter Oliphant	Microsoft VC .NET	2	4th Oct 2007 01:37 AM
Creating a Subset Report	=?Utf-8?B?Qm9i?=	Microsoft Excel Worksheet Functions	2	13th Nov 2006 03:52 PM
creating a database subset in vba	=?Utf-8?B?UGF1bGEgR2FsbG93YXk=?=	Microsoft Access VBA Modules	3	25th Jun 2006 03:48 AM
How to enter symbols for subset or element of a subset in Excel?	=?Utf-8?B?cndjaXRh?=	Microsoft Excel Worksheet Functions	1	23rd Jan 2006 09:27 PM
Creating a subset table/view	Sabine	Microsoft ADO .NET	1	30th Oct 2003 01:21 AM