MS Excel Script

I have an Excel spreadsheet , a sample of it is shown below.

Screen-Shot-2017-12-20-at-7.29.55-PM.png
I would like to have each EmpID in a separate worksheet that will display
Date by older date on top row
EmpID
Cost

I do not need it to display Daily .. I need just Week End

that would be perfect if I can have a Chart (Histogram) added on each worksheet of the EmpID, based on Cost for each Date (older date first on the left).
it will display how the cost of each EmpID has fluctuated from 01/2017 going forward to more recent day.

I wonder if there is a script that can accomplish this ?

Thank you very much
jskfanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
There are a couple of options in Pivot Tables that you could use.

Double Click for Detail
When you create a Pivot Table you can double click on a value  and it will create a separate sheet showing just the elements that made up that item.

Page Filter Report
Create the pivot table and use Employee ID as a Page Filter. With the cursor in the Pivot Table there will be a Ribbon/Tab with menu choices. Over to the far left there is a button for Pivot Options with a dropdown next to it. Select the dropdown and one of the Options is "Show Report Filter Pages". Select this and you will get a list of items that are being used as page Filters (Employee ID); click OK and it will create a sheet with a replica of the Pivot Table filtered for each Employee.
0
ShumsExcel & VBA ExpertCommented:
In attached run macro "CreateAndSortEmpID":
1. It will create separate sheets as per Employee IDs.
2. It will display just Week Ends.
3. It will sort as per older dates.

Sorry I cannot help you with Charts.
AutoFilter-More-Than-2-Criteria-Cop.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
Thank you to Shums for creating the sample data.

With that data I have created a Pivot Chart for what I believe you want to see.

The chart is created from the Pivot Table; changes to the table will be reflected in the chart and likewise changes to the chart will change the table. Use the EmpID filter in the table or the chart to change Employee

See attached.
Pivot-Filter.xlsx
0
jskfanAuthor Commented:
Thank you Guys..We'll try it later
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.