Looking for Excel VBA Coder - Please download Instructions
$30-250 SGD
In Bearbeitung
Veröffentlicht vor fast 5 Jahren
$30-250 SGD
Bezahlt bei Lieferung
I'm Looking for Excel VBA Coder Who can use Teamviewer to work on my sheets. Please quote me a price.
The Codes that I require are pretty simple, with a 10 steps example below that I'm currently using:
Sub StepOne_CopyF3DownPasteAR4()
Range("F3", Range("F3").End(xlDown)).Copy Range("AR4")
End Sub
Sub StepTwo_SelectRangeFromAR4Down()
Range("AR4", Range("AR4").End(xlDown)).Select
End Sub
Sub StepThree_SortRangeFromAR4Down()
Range("AR4", Range("AR4").End(xlDown)).Sort Key1:=Range("AR4"), Order1:=xlAscending, Header:=xlNo
End Sub
Sub StepFour_RemoveDuplicateCellsFromSelectedRange()
'PURPOSE: Remove duplicate cell values within a selected cell range
'SOURCE: [login to view URL]
Dim rng As Range
Dim x As Integer
'Optimize code execution speed
[login to view URL] = False
'Determine range to look at from user's selection
On Error GoTo InvalidSelection
Set rng = Selection
On Error GoTo 0
'Determine if multiple columns have been selected
If [login to view URL] > 1 Then
On Error GoTo InputCancel
x = InputBox("Multiple columns were detected in your selection. " & _
"Which column should I look at? (Number only!)", "Multiple Columns Found!", 1)
On Error GoTo 0
Else
x = 1
End If
'Optimize code execution speed
[login to view URL] = xlCalculationManual
'Remove entire row
[login to view URL] Columns:=x
'Change calculation setting to Automatic
[login to view URL] = xlCalculationAutomatic
Exit Sub
'ERROR HANDLING
InvalidSelection:
MsgBox "You selection is not valid", vbInformation
Exit Sub
InputCancel:
End Sub
Sub StepFive_CopyPasteTransposeAR4DownToAR2()
Range("AR4", Range("AR4").End(xlDown)).Copy
Range("AR2").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, Transpose:=True
End Sub
Sub StepSix_CopyPasteTransposeAR4DownToAR3()
Range("AR4", Range("AR4").End(xlDown)).Copy
Range("AR3").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, Transpose:=True
End Sub
Sub StepSeven_CopyPasteTransposeAQ3DownToAR3()
Range("AQ3", Range("AQ3").End(xlDown)).Copy Range("AR3")
End Sub
Sub StepEight_GiveFormulaToAR3()
Range("AR3").Select
[login to view URL] = _
"=IF(RC37=""Ignore Odds"","""",IF(OR(RC6=R2C,RC7=R2C),IF(RC6=R2C,RC42,IF(RC7=R2C,RC43)),""""))"
Range("AR4").Select
End Sub
Sub StepNine_CopyFormulaFromAR3AndPasteToAll()
Range("AR3").Select
[login to view URL]
Range(Selection, [login to view URL](xlToRight)).Select
Range(Selection, [login to view URL](xlDown)).Select
[login to view URL]
End Sub
Hi,
I have gone through the complete description and i am good at macros, Database and advanced excel with extensive experience of 5+ years which I would consider myself as the best approach for this project. let me if my skills and experience can come in handy for you.
$46 SGD in 3 Tagen
5,0 (3 Bewertungen)
2,1
2,1
15 Freelancer bieten im Durchschnitt $165 SGD für diesen Auftrag
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
VERY EASY FOR ME
Hi, Nice to meet you.
When it comes to Excel, I am an expert
Please see product I made recently using VBA and C#, python, java, excel management
https://www.freelancer.com/projects/excel/Excel-Macro-pull-data-from/?w=f
https://www.freelancer.com/projects/excel/Excel-VBA-Time-Series-Decomposition-20459676/?w=f
https://www.freelancer.com/projects/excel/Build-appraisal-record-card/?w=f
https://www.freelancer.com/projects/visual-basic-for-applications/Connect-Word-Userform/?w=f
https://www.freelancer.com/projects/excel/Need-HELP-this-excel-form/?w=f
https://www.freelancer.com/projects/php/create-outlook-add-rule-shortcut/?w=f
https://www.freelancer.com/projects/data-entry/add-excel-table-rows-outlook/?w=f
https://www.freelancer.com/projects/excel/Convert-Text-file-XML-file/?w=f
https://www.freelancer.com/projects/data-entry/excel-expert-19406573/?w=f
https://www.freelancer.com/projects/php/create-csv-file-using-parshub/?w=f
https://www.freelancer.com/projects/excel/Compare-CSV/?w=f
https://www.freelancer.com/projects/excel/ascii-excel-converter/?w=f
https://www.freelancer.com/projects/software-architecture/Excel-xml-file-online-wizard/?w=f
https://www.freelancer.com/projects/software-architecture/Combination-creator/?w=f
I have a lots of experiences in Excel, Access and VBA programming
After complete project, I can support fixing bugs with free.
and support update features with low price.
Please contact me.
Thanks
Hi,
You may not select the right candidate without knowing what your project on writing some Excel VBA codes on your Excel sheet over Teamviewer will look like. Fortunately, I can complete a part of your job before you award the project.
I have vast experience working on similar projects and I am confident I can exceed your expectations. I am passionate about flawless results and I can assure you of a job well done.
I am ready to start working on the sample right away and I HAVE TEAMVIEWER INSTALLED ALREADY. Will you be available for a quick chat?
Thanks for your time.
Hi, there
I hope all's well with you.
I can code that maybe better to use SQL/ADO with vba coding within Excel.
I'm Ms Access/VB/SQL/Excel programmer since 1997.
Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects.
Please visit :https://www.freelancer.com/u/zu02?w=f
Thank you for your consideration.
Zura
Sir,
I am well versed in these kind of jobs and can do your project as per requirement.
**I am ready to start
Waiting to hear from you.
Regards
Relevant Skills and Experience
Data entry, excel
I am postgraduate with more than 5 years of experience in advanced excel based tools, VBA automation, google scripting and data processing. I have successfully completed similar projects, please have a look at my portfolio for details.
I have developed excel based automation tools for Ernst and Young also.
You can get your work done here with highest quality at lowest price. Actual price and timeline will be decided after a discussion on exact requirements.
Looking forward to work with you
Hi. How are you?
I read your description carefully and am very interesting in your project.
I can start right now and can help you.
If you hire me,i will do my best for your job and you can get the best results.
Looking forward to hearing from you.
Thanks.
Hi. Great app writer for your projects. I have writen scraping, excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
Hi,
I have checked your attachment and able to do this as per your requirement. I am very good in excel vba, macro etc.
Please check my profile.
Thanks
Hello,
I have just gone through your requirement.
I understand your requirement completely and I can do your work and I am able to Start ASAP.
Please see my portfolio if you want to know my skill and experience.
https://www.freelancer.com/u/milindaudichya
Please contact me for further discussions.
Kind Regards
Milind A.
Make contact to talk. We will be able to remotely move spreadsheets with the software T ea m V ie wer. I have been working with macros for over 20 years and I will do a great job for you.