creating a VBA macro - repost
$10-30 USD
Πληρώθηκε κατά την παράδοση
Hello freelancers
I need a simple vba macro that performs the following tasks
Download the sample Contoso excel workbook with Powerpivot model.
[url removed, login to view]
Go to Inventory worksheet and expand the rows to look like the following screenshot
select a cell in the PivotTable
The VBA code needs to export into a new sheet
1. Work out that the activecell is part of the Pivot table called “PivotTable2”
2. The Row position is
a. [StoreName]=”Contoso Vancouver No 1 Store”
b. [ProductName]=”Contoso 2G MP3 Player E200 Blue”
c. FullDateLabel = “2008-10-18”
3. The Column Position is
a. CalendarYear = 2008
4. The Filters are
a. RegionCountryName = “Canada”
b. CityName = “Vancouver”
c. ProductKey = “7|8”
Note that c is a multi select filter
Regards
Ταυτότητα Εργασίας: #4979970
Σχετικά με την εργασία
14 freelancers κάνουν προσφορές κατά μέσο όρο $43 για αυτή τη δουλειά
Hello, I am a .NET, VBA and VSTO software developer. I have nine years of experience in programming. I rest-assure that I will complete the work on time and deliver you the completed work to your satisfaction.
Expert here I can start today .. Please ref: https://www.freelancer.com/users/feedback_931653.html for my quality and client satisfactory work .
Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SE Περισσότερα
Consider it done...done professionally! Consider it done...done professionally! Consider it done...done professionally!
We provide you industry standard Mobile Apps, Software, Desktop Apps, Web Stores, Websites and Web Apps. So, you get all at one place! We can provide you the following: - iOS applications - Android applications - Περισσότερα
Hi, can help you with the macro immediately. Have gone through the sample worksheet. Let me know if you are keen to award the project.
Hi, I am working as a quantitative analyst in financial services domain. May day to day work involves automating tasks using VBA macros
As mentioned in the project description, its a simple VBA macro and would not take much time for an experienced VBA programmer. Looking forward to receive your response!!
Hi, I have been building Macros from past 3 years and has automated various things using vba macros.
Tôi đã làm nhiều chương trình bằng code VBA như thế này. Tôi tự tin có thể hoàn thành công việc này .
Greeting, We are from GD Tech Solutions. We have understood the work and would like to submit our proposal for the same. Why Us: - We have extensive experience in Excel & VBA scripting. - We have done simil Περισσότερα
I am unable to downloade ppt. As I understand the Work VBA needs to filter the content and paste it in other sheet. Filtering Condition is based on PIVOT table and some more date. Please note : I Περισσότερα
I was doing the same process for a daily report on my regular work so this will be an easy task for me.
