Question: I need to create Pivort table in VBA macro for below file, it needs to be created in another new sheet in excel. kindly share

I need to create Pivort table in VBA macro for below file, it needs to be created in another new sheet in excel.

kindly share the vba codes.

I need to create Pivort table in VBA macro for below file,

A B D 1 CLIENT CODE Quatity 10 2 3 EKRO EKRO 11 Item Mango Banana Apple Orange Cocoa UOM No's No's No's No's No's 4 EKRO 23 5 EKRO 8 6 EKRO 59

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

I need to create Pivort table in VBA macro for below file, it needs to be created in another new sheet in excel. kindly share the vba codes. A B D 1 CLIENT CODE Quatity 1 0 2 3 EKRO EKRO 1 1 Item...

Q:

Liting Wang Shelly Cashman Excel 2013 Chapter 10: SAM Project 1a Submission #2 Score is 79 out of 100 1. Go to the Event Schedule - 2018 worksheet and use the password J@Nuary18 to unprotect the...

Q:

PROJECT DESCRIPTION Patrick Fitzgerald is the director of Career Development at Finn Technical Institute, a local community college. The Institute offers workshops on resume writing, interview...

Q:

Liting Wang Shelly Cashman Excel 2013 Chapter 10: SAM Project 1a Submission #2 Score is 79 out of 100 1. Go to the Event Schedule - 2018 worksheet and use the password J@Nuary18 to unprotect the...

Q:

Step 1: Import and Clean Up Text File Download starting student Excel file and the text file. Open the starting Excel file and navigate to Sheet1. Import the text file by using the Get External Data...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

New Perspectives Excel 2016 | Module 7: SAM Project 1a Reclaim the River DEVELOPING AN EXCEL APPLICATION GETTING STARTED Open the file NP_EX16_7a_FirstLastName_1.xlsm, available for download from the...

Q:

Is it possible to provide a video to illustrate the way to create the excel New Perspectives Excel 2016 | Module 7: SAM Project 1a Reclaim the River Developing an Excel Application GETTING STARTED...

Q:

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

Q:

How do you prepare the following journal entries needed after the beginning balance? Global Bike, Inc. 1a (Excel) 2015 WINT ACCY 310 - Accounting Systems Due, Monday, Jan 12, 8am Estimated time to...

Q:

Specify a floor steel deck that can support the following loading conditions: DL = 1.5 KPa LL = 3.6 KPa Use the thinnest steel deck and assume unshored 3-span is applicable.

Q:

Review the following scenario: Your employer is planning to shift resources from employing a direct sales method to using distributors and creating an online direct distribution presence. As a...

Q:

The divisions in a divisional organizational structure can correspond to either products or

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Q:

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

Q:

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...