Creating a Subset Report

G

Guest

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.
 
G

Guest

Hey Bob,

Can you tell me the criteria for your new sheet? If it meets the
requirements, then a pivot table might be a solution. Else, I need to think
more.
 
G

Guest

Hi Vijay,
My criteria would be similar to what I do today with AutoFilters in a couple
of columns. Does that help?
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop-down list Populated by a Subset of a larger list 3
IF 3
Creating subsets 1
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
Auto fill in forms 2
Date Help 1
Transfer Subset of Data to Separate Worksheet 5
Need Formula 1

Top