Closed

creating a VBA macro

This project received 17 bids from talented freelancers with an average bid price of $28 USD.

Get free quotes for a project like this
Employer working
Project Budget
$10 - $30 USD
Total Bids
17
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online