CODEWITHSUNDEEP
excelexcel-formula
AgileMan
AgileMan

Reputation: 35

Excel: How to dynamically load data from one tab, and display in another sorted differently?

Assume I have two tabs. One that has Data, and the other a Sorted Summarized view.

The Data tab has a bunch of columns for misc data I don't need on the summarized view

The Summary tab wants to take 3 of those columns, and sort the rows by 1 of the columns from Data.

In the data tab, I have a "score" column for each row. New items will get added to the Data list, and the data tab will be sorted by Date of request.

However, in the Summary view, things are sorted by the Score value.

  1. I want to be able to add new rows to the data column or make edits to the items in the Data column and have those changes be reflected in the Summary column.

  2. I'll need the "header" to stay at the top of the page, and just sort rows 2 on down...

  3. I'll need to "carry over" a "description" column, and a "Business Unit" column from the data tab into the summary tab.

Upvotes: 0

Views: 1211

Answers (1)

vasin1987
vasin1987

Reputation: 2012

Pivot table has row labels, column labels and values.

put "carry over" , "description" and "Business Unit" into column label and "score" into values

you can use many aggregate function in values field.

Upvotes: 1

Related Questions