Find Jobs
Hire Freelancers

Excel File VBA maintenance and update

$10-30 USD

Cancelled
Posted about 9 years ago

$10-30 USD

Paid on delivery
I am an IT enthusiast, but I am not too good with programming or VBA. As a side project, I am compiling some data and would like to make it user friendly. In an excel file I have been developing insofar, I have been successful in implementing different functions throughout, by the help of some individuals here, friend circles, and myself through research. Through this listing, I am seeking someone to cooperate in the long term future, as well as current tasks which I need to take care of. My pre-requisites, is that you understand how to communicate, you speak English at a standard level, are an expert at VBA, data entry and can develop a relationship for the long term, therefore a responsible individual all around. Hence, only individuals with a 'repeat hire rate' of 30% and above need to apply or bid. You can have a look at the file attached and let me know whether you understand the code, and are able to work with it in the long term? I already have some tasks which you could help with, input a 'sort' criteria in Listbox UserForm and a 'find' function. Additionally, I would also like to consult in how to better improve the file and coordinate data a little better. The priority is to discuss maintenance and update costs for the file for the long term. The initial tasks, I will pay up to 30$, but that includes time it will take for you to look at the file and coordinate yourself for the maintenance when needed, after that I only need editing the code slightly, to refine little details here and there. There is only little code and for an introduction to waste less of your time, we can have a skype session to ease communication and get a head start. If you understand what I seek, then feel free to send me a message, but...I'v had some issues here with some freelancers where, they told me that 'overcharging' and 'over budget' is a tradition in freelancers. I have also had contact with people who wrote code and did not know what and how they wrote it, or perhaps they only recorded macros, so when asked to modify slightly, it took them 2 hours instead of a few minutes. I have also had individuals who told me they wrote new code, when they did not, after inspecting the file I found the same code I had put in there. Lastly, only to shift some cells and make some minor changes to their code (approx. 5 minutes of work), they wanted to charge me 20$, and so on and so on...If you adhere to such principles, please, steer clear.
Project ID: 7230776

About the project

16 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

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
16 freelancers are bidding on average $27 USD for this job
User Avatar
Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# I have done projects related to VBA and VB in past. I am currently going through all the attachments to have a clear view. If you like my proposal,lets start. Thanks Abhinov
$30 USD in 1 day
5.0 (23 reviews)
4.6
4.6
User Avatar
The sort feature pretty simple but the Find is a little different. in the JPG file where are you getting the list from? Doing an Autofill is kind of outside Excel. For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been doing my contracting work with VWorker/Freelancer for the past 3 years; during that time I have completed 70 projects ranging from Excel/Access VBA to SQL Server database constructions. In my experiences over the past 3 years I know how daunting it is to try and describe what you are wanting along with sifting through numerous bids. As you can see from my reviews I strive to make sure my customers are happy with my services. I take a lot of pride in my work and stand behind anything I create. Please feel free to ask any questions I am always willing to share my experience. Best of luck with your search. Michael
$35 USD in 1 day
5.0 (21 reviews)
4.7
4.7
User Avatar
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$35 USD in 1 day
5.0 (9 reviews)
3.8
3.8
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD in 5 days
5.0 (3 reviews)
1.8
1.8
User Avatar
Your idea seems interesting to me I am willing to work for long term I am working in excel VBA for last 3 years not counting 4 years of engineering in computer science. Please give me the opportunity.
$10 USD in 7 days
5.0 (2 reviews)
1.7
1.7
User Avatar
i made a sample for you to test. its 80% done(sorting and search mechanics as was requested), only some minor bugs and polishing left to be made. i need you to contact me so i could send you a working .xlsm file. Before you contact me i unable to send you personal messages/files
$25 USD in 1 day
5.0 (2 reviews)
0.9
0.9
User Avatar
Hi, I have read the requirement. First requirement is very easily doable. 2nd requirement.. I will have to explore few options to make the Find automatically work as we type the text. I have all the qualities which you are looking into a coder. I am a VBA expert and can speak very good English and I am here for long term relationship with the client. Below is my understand about the code in my simple language. I tried to go though 2 macros. ----------------------------------------------------------------- Macro in the worksheet "Competitions' If the Pname is NULL or equals to DEFAULT values then display a message box " Enter all required details" If Pname is Not NULL then fill the data into the rows of last used cell ----------------------------------------------------------------- ----------------------------------------------------------------- Macro in the worksheet "Practice List" A list box is called from Forms "Location" The values to the LIst box is assigned from range "countrycapital" which resides in worksheet "Country Demographics" Column C ----------------------------------------------------------------- Best Regards, Abhay Singh B Skype ID: abhaysinghb
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a VBA developer and have worked in a software firm extensively on excel programming for a US client which included accessing database using SSAS etc. I am ready to work for long term with you. I will deliver the work with desired quality. I an also available on Skype for further discussion.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, The sample work will be shared with you initially, to check if the work is moving in right direction, correctly. Regards Amit Bajpai
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hi my name is furqan and i am a student of computer science and i am interested in your project just send me the data and i will start working on your project
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello My name is Angus I have over 5 years of experience with VBA and VB.net applications. I have worked with big business creating application to speed up tasks and streamline jobs. I speak fluent English. I have looked at your spreadsheet and can easily add the changes you are after. I am new to freelance and have never bidded on a project before so please give me a chance. I would be able to complete this for you with in 24hrs. I look forward to hearing from you. any questions please don't hesitate to contact me. kind regards, Angus
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience in working in VBA. I have a proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am willing to discuss further about the project specifications and deliver the same to your needs .
$34 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I HAVE MORE THAN 10 YEARS OF EXPERIENCE IN EXCEL,WORD,MS ACCESS,POWER POINT AND ALL KINDS OF DATA ENTRY.
$25 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CHINA
London, China
5.0
1
Payment method verified
Member since Apr 11, 2008

Client Verification

Other jobs from this client

Do some Excel Work
$10-30 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.