VBA to auto sort pivot table

$8-15 USD / hour

Completed

Posted

almost 9 years ago

$8-15 USD / hour

I have a pivottable called "pivottable3" and it has Column labels "Fund" and Row labels "Sector". In the Column labels "Fund" I selected "A" and "B" and the value is just the actual number. Now I need a vba code to refresh the table (still have A and B filtered) and always sort the table according to the values in "A" from largest to smallest. This is my code, and obviously not working. With [login to view URL]("PivotTable3") .AutoSort xlDescending, "A", [login to view URL]("PivotTable3").[login to view URL](1), 1 End With

Data Entry

Data Processing

Excel

Project ID: 7928597

About the project

14 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@cgullapalli

Hi, I am good at excel and vba. I would like to discuss on this project. Looking forward to work on this project.

$15 USD in 2 days

5.0

(1171 reviews)

8.4

14 freelancers are bidding on average $14 USD/hour for this job

@prameswara

Hello Sir, Im excel VBA macro and formula Expert :) i can make auto sort pivot table like u want :), its easy for me :) please see my feedback ( the most of work that has been done its about macro VBA excel project ) :) thank You Sincerely Prameswara :)

$8 USD in 3 days

4.9

(437 reviews)

7.6

@Teloquence

Consider it done. Check my past reviews for your reference eagerly looking forward for your reply so that I can start with the implementation

$15 USD in 8 days

4.9

(339 reviews)

7.7

@zExcel

A proposal has not yet been provided

$25 USD in 3 days

4.9

(257 reviews)

7.7

@dangersystem

Hello there, I can do this work according to your requirements. i am able to handle this with my best care and creativity. I have done this type of data entry project previously.i assure you that i can complete your project with a minimum time and any types of error free work. Sir, Please take a look in my profile and reviews and if you like that, please give me a message immediately to discuss about the work ! please reply me asap,i am waiting for your reply.... Thanks, dangersystem

$8 USD in 3 days

4.9

(120 reviews)

5.7

@renesontiongson

Hi! pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me with your actual data.

$10 USD in 3 days

4.9

(76 reviews)

5.7

@milanmartinjuk

Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Access and VBS tinkering. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan

$8 USD in 3 days

5.0

(22 reviews)

4.3

@ssumit2606

I am a certified MS Excel Expert with good knowledge of VBA and Macros and can help you write the perfect code. Please allow me to start and share the sheet

$14 USD in 3 days

4.8

(8 reviews)

2.8

@logoDS761

HAVE VERY STRONG EXPERIENCE IN VBA FOR EXCEL 2010 - 2013 HAVE VERY STRONG EXPERIENCE IN VBA FOR EXCEL 2010 - 2013

$13 USD in 3 days

5.0

(3 reviews)

2.5

@mreugenecarter

I have completed the VBA code, if you wish to accept my bid, I can email you the VBA code, or if you want to send me the excel sheet, I can embed it and assign it to an object that you can click to refresh.

$12 USD in 10 days

0.0

(0 reviews)

0.0

@prawinnaidu0205

I am an MIS analyst. My Daily job involves automating excel tasks using VBA, creating interactive dashboards and PowerPoint presentations. I am also good at data analysis, data entry, data filtering using formulas , pivots and creating reports with charts.

$12 USD in 3 days