Recap Ecel worsheet

$10-30 USD

Closed

Posted

about 5 years ago

$10-30 USD

Paid on delivery

having difficulty changing this macro to sorts on an excel protected worksheet Private Sub WhichWeek() ' ' WhichWeek Macro ' Macro recorded 4/1/2014 by Tony ' ' [login to view URL] [login to view URL] Reference:="PreCopyToThisWeek" [login to view URL] Down:=-8 [login to view URL] Range("B11").Select [login to view URL] Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False [login to view URL] = False [login to view URL] Key1:=Range("B11"), Order1:=xlAscending, Key2:=Range( _ "C11"), Order2:=xlDescending, Header:=xlNo, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2 _ :=xlSortNormal [login to view URL] Reference:="OneDecimalPlace" [login to view URL] = "#,##0.0_);[Red](#,##0.0)" Range("a1").Select Range("b10").Select Range("b1").Select [login to view URL] End Sub

.NET

C# Programming

Excel

Software Architecture

Visual Basic

Project ID: 18989075

About the project

18 proposals

Remote project

Active 5 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

18 freelancers are bidding on average $26 USD for this job

@schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

$41 USD in 1 day

4.9

(337 reviews)

7.9

@P0L

Hello, I’m an Excel VBA expert and I can fix your macro. Please check my profile and contact me to discuss further details. Regards.

$25 USD in 1 day

4.9

(314 reviews)

7.3

@ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the file - I can fix the code to work with data. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi

$15 USD in 0 day

5.0

(189 reviews)

6.9

@zebracaro

I can do it for you quickly and exactly . Please contact me for saving your tie and your money .

$25 USD in 1 day

4.9

(123 reviews)

7.0

@dgled

Hi, I can do it for you now. I am an expert and guru in Financial, Math and Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.

$50 USD in 1 day

4.9

(83 reviews)

7.1

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards

$15 USD in 0 day

4.9

(232 reviews)

6.9

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

$25 USD in 1 day

5.0

(110 reviews)

6.3

@vbexcel

Hi; I can get this done for you today. Please see my Portfolio for samples of my work. Regards Zenon

$15 USD in 1 day

4.9

(36 reviews)

5.6

@shahinrahimi

I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. Please feel free to contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS, ...} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin

$20 USD in 1 day

5.0

(36 reviews)

4.6

@ielucerotrad1

I can do the job! I would suggest some changes to make it not necessary to select ranges. (more solid coding and less prone to errors) I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project, Autocad, pdf, CorelDraw, etc.), web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6.

$15 USD in 1 day

5.0

(15 reviews)

3.9

@coppercoder

send me some data and i will fix, test and send back tonight

$25 USD in 1 day

5.0

(1 review)

1.9

@pogodin

Hello ! My experience with vba is more than 10 years. Can You clarify what difficulty with worksheet and provide examples of xls files ? Thank You. Regards, Alexei.

$15 USD in 1 day

5.0

(1 review)

1.4

@TumblingWave

Hello, I can look at this for you. I have many years of Office macro experience. I am just finishing an Office macro project, awarded to me as follows: https://www.freelancer.com/projects/word/CREATE-SIMPLE-WORD-MACRO/?w=f

$25 USD in 1 day

4.8

(2 reviews)

1.2

@DeltaIntelitech

Dear Prospect Client, I hope you are doing well! I am very good at VBA/Macro and Excel. I have 11+ years of experience working with multiple MNCs in the same profile (Data Processing/Integration/Validation/Cleansing/Modelling, Dashboard, Reporting, Process Automation, Statistical Analysis, Forecasting, Power BI Reporting, etc). Please allow me to help you with debugging the code, It is a job of a few mins to an hour. Let's discuss the requirement in detail if you wish to continue. Please review the work samples in my portfolio. With me, you get on time and accurate delivery, timely update, the SOP of the Process (if any), pleasant working experience, best Project Management as I am PMP certified Project Manager and Analytical and Solution Oriented Approach. Hope to hear back soon Thank You Ajay

$25 USD in 1 day