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

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.


"Bob" wrote:

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

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


"Vijay_India" wrote:

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.


"Bob" wrote:

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