Excel File VBA maintenance and update
$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.
I have been pondering around to structure and restructure my opinions on the work required for the file in the long run. Based on feeback I would please like an asnwer to the following questions:
How long have you been working on VBA?
Considering the file, if the file was to be made by you:
How long would it take you to incorporate the 'sort' criteria?
How long would it take you to incorporate the 'find...' function in the Listbox Userform?
As I have mentioned, my intentions are genuine, I am not trying to under pay, I am trying to not get taken for granted as some have already tried so. My company is not paying for the project, it is coming out of my own pocket.
Just to give you an idea, I intend to pay up to 80$-100$ / hour, if you understand and know VBA at an expert skill level, therefore, if a a job requires 10 minutes, that would imply around 16$ going in you account, my only aim is to avoid paying 200$-300$ / hour, and, build on a relationship that will last throughout, my objective would be around an hour or so of work every 1 / 2 months, however that is to be confirmed at a latter time. Additionally, I would like to work with someone that, when I have a new project, someone that needs help with their project, I can just send 'my guy' a message. i would like to be a regular, not just the tasks stated above.
Project ID: #7230776
About the project
16 freelancers are bidding on average $27 for this job
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 More
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 A More
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 Serv More
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.
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. Befor More
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 More
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 More
Hi, The sample work will be shared with you initially, to check if the work is moving in right direction, correctly. Regards Amit Bajpai
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
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 hav More
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.
I am willing to discuss further about the project specifications and deliver the same to your needs .
I HAVE MORE THAN 10 YEARS OF EXPERIENCE IN EXCEL,WORD,MS ACCESS,POWER POINT AND ALL KINDS OF DATA ENTRY.
