Help with creating a way to pull data from data set

[almst791]

Ok guys here is my situation. I have a data set with many columns and rows of data. within this data there is a "Cost Center" Column in column AR. There is an "employee" column in column K and there is a "total spend" column in column "G". Each month I will be adding data to these columns. I want to have a tab for each "Cost center" there is a total of 50 cost centers so I currently have 50 tabs with just the name of each cost center, within each tab I want just the specific list of employees that are associated within that cost center (which is all in the data tab). So in each tab I need the list of all employees in that cost center and a sum of their total spend from the data tab. I need these lists to update each month, is there any sumif, match or index functions I can use to pull this data? Somenone, anyone!? Thanks!

[ImranBhatti]

It seems that it can be done with formulas.Would you please upload a sample workbook with desensitized data?
Add some desired results manually to understand what you need.

[Pete_UK]

I think that rather than have one tab for each cost centre (and thus have 50 tabs), it would be neater if you just have one tab on which you can use a drop-down to select one cost centre from the list of 50, and the appropriate data will then be displayed for the chosen cost centre. Then you can select another cost centre and get a different set of data displayed, and so on.

To show you how to do this, it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

[almst791]

It seems that it can be done with formulas.Would you please upload a sample workbook with desensitized data?
Add some desired results manually to understand what you need.

I have attached an example, so the first tab is the data tab; This data is always going to change except for the cost center numbers, new employees will come in but will always be assigned a cost center. Tab 1 2 and 3 are all the cost center tabs where I want a list of employees associated with that cost center and the sum of their spend. This example is minimized from my actual dataset. thanks for the quick response.

[almst791]

I think that rather than have one tab for each cost centre (and thus have 50 tabs), it would be neater if you just have one tab on which you can use a drop-down to select one cost centre from the list of 50, and the appropriate data will then be displayed for the chosen cost centre. Then you can select another cost centre and get a different set of data displayed, and so on.

To show you how to do this, it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

This is exactly what I did. I had a drop down for specific cost center then had a VBA that changed a pivot tables filter according to the drop down so the list of the specific cost center then it would populate with employee names would update every time it was changed. But I cannot do this, my company wants a static setup with set tabs for each cost center.

[Pete_UK]

... my company wants a static setup with set tabs for each cost center ...

Okay, good luck with that approach, then.

Pete