find and Summarize data in a table from a different sheet?

R

Richard Z SF

I have a master sheet that has a table with rows of data. The first 3 columns
of each row contain information that categorizes the rest of the data in the
row. I want to create a summary sheet that looks in this master sheet and
displays only rows of a particular category.

If it helps the data is an export from a bug tracking software and I want to
be able to display on a sheet all the bugs for an individual designer from a
particular area of the product and the detail about the bug. All of this
information is included in each of the table.

Thanks
 
R

Richard Z SF

I could but I want summarize it on different sheets in different ways. I
think if I filter the data I have to do it in the table itself and I need to
do it every time I want to look up a new user.
 

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

COUNT rows on external sheet if between date range 3
Macro to Compile Data from Different Sheets 2
Pulling data from Sheets in A workbook 2
creating a report from a table, pivot table not suitable 1
Copy Data from 1 Sheet to Another 3
Summarize information on another sheet 8
Dynamically sized table compiled from unsorted rows with blank entries 2
Main Form - copy exact data from multiple worksheets with live lin 1

Top