Find Jobs
Hire Freelancers

Excel Manipulation

$30-250 USD

Ακυρώθηκε
Αναρτήθηκε πάνω από 5 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
Needing a script coded to take data from an existing Excel sheet and make a few changes to one Column. I need a script that will delete certain unwanted data in Column A and replace it with what I need. In addition, if there is no data to delete I need it to simply add on to the existing data. It's very important that it skips any cell within that column, that does NOT have data. Ex. 123 Main, DA I would want the "DA" removed and add " , Dallas, TX" Ex. 123 Main I would want it too add ", Dallas, TX" I will need a drop down menu to select what I want inputted into each cell, between a few choices. 1. , Dallas, TX 2. , Fort Worth, TX 3. , Arlington, TX Looking for a clean UI, as I will be adding tools like this in the future, as they are needed and want them kept in one location. It's important that you understand Microsoft's weaknesses, which are plenty I know, but you should know how to work with it. I will NOT accept a Macro, Python or anything with Java in it's name. have that now and it's been a disaster, twice. If it was my choice it would be VB. It's also important to know that I currently have a VPS running Windows 2008 Server, I cannot upgrade with my current host, but will be looking at other hosts at some point. For now, it's 2008 Server. Faster the better on delivery
Ταυτότητα εργασίας: 17623959

Σχετικά με την εργασία

29 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
29 freelancers δίνουν μια μέση προσφορά $131 USD για αυτή τη δουλειά
Avatar Χρήστη
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you with Excel Manipulation I have more than 5 years of the experience in Excel, Visual Basic Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. Thanks.
$250 USD σε 3 ημέρες
4,9 (353 αξιολογήσεις)
8,0
8,0
Avatar Χρήστη
Hello. I'm a vb.net programmer. I have written many programs like the one you like. I will write a program with a simple user interface which can interact either with a txt file or eg an access or even another excel so you can set up parameters. You can also add them real time inside the program. After this you will just have to press one or two buttons depending on what you need to do and everything will be changed. It will be customizable so we can add extra code and operations in the future. And of course it will run in any windows computer or windows server. I can have it ready within 1-2 days. Please feel free to message me if you need to discuss this further. Regards, Marina Louki
$111 USD σε 1 ημέρα
5,0 (125 αξιολογήσεις)
6,5
6,5
Avatar Χρήστη
Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can discuss. Thanks.
$30 USD σε 3 ημέρες
5,0 (173 αξιολογήσεις)
6,2
6,2
Avatar Χρήστη
- Went through the explanation provided wanting to replace the Col A with the value that you wanted to Search and replace it with another value - as given in example DA to Dallas, TX - Additionally needing options in a dropdown to have "What to be replaced by" - The solution could be done via VBA scripting, have done some complex solutions - Will provide a GUI where you enter the string value and a dropdown to specify "what to be replaced by" and you click the button it would replace the values. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
$160 USD σε 4 ημέρες
4,7 (51 αξιολογήσεις)
6,0
6,0
Avatar Χρήστη
Hi there, I know the weakness of Excel in VBA applications. So I can write a C# program (can be run on Windows) that takes control of Excel file and manipulate data stored on that file. Let me know if it works for you or not. Mehrzad
$60 USD σε 1 ημέρα
5,0 (35 αξιολογήσεις)
5,3
5,3
Avatar Χρήστη
Hi, i will help you in this project by creating a VB.NET stand alone tool, that you will select the workbook you need to do the changes on, and select any other options we will agree on, then Hit Start. that's it! i have done so many projects like this before you can check my profile . let me know if you like the idea, regards
$150 USD σε 3 ημέρες
5,0 (30 αξιολογήσεις)
5,4
5,4
Avatar Χρήστη
Hello sir, I am interested in your project. I would like to discuss details via pm. Yours sincerely,
$49 USD σε 3 ημέρες
5,0 (25 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
Hi I'm an Excel expert with years of experience - VBA programming, web scraping, data analysis, pivot tables, lookup, formulas, etc Please provide more details. Best regards, Denis Poduzov
$55 USD σε 3 ημέρες
5,0 (24 αξιολογήσεις)
5,0
5,0
Avatar Χρήστη
I am very able to create a excel macro to suffuce your requirement. I am ready to start.
$156 USD σε 2 ημέρες
4,6 (45 αξιολογήσεις)
5,5
5,5
Avatar Χρήστη
Hello, sir i can write VB program to load your excel file then by one change it will update the cell values based on your requirements Thank you
$35 USD σε 1 ημέρα
4,9 (63 αξιολογήσεις)
4,7
4,7
Avatar Χρήστη
Experienced project professional, US based, MBA, EXCEL and MS Project expert; also experienced with data transformation and PDF to EXCEL tools. I would be glad to assist with your project. Thanks _____________________________________________________________________________________________________
$133 USD σε 3 ημέρες
5,0 (31 αξιολογήσεις)
4,5
4,5
Avatar Χρήστη
Hi, Came across your requirement, and believe this can be best accomplished by VBA coding. I understand your requirement of changing the existing cell value (Non-Blank Cells in Column A) with the selected drop-down data. I believe what you also need is an option to seamlessly add additional values in the dropdown, for any future changes that come along. I will be glad to get this programming done for you. I have over 15 years of experience working on creating customized excel based solutions for companies like Dupont, Walmart, Accenture, Sams Club etc. I take pride in the quality of work I do and the product I deliver. Feel free to message me for any queries or concerns and I will be glad to address them Regards Amin
$175 USD σε 1 ημέρα
4,9 (6 αξιολογήσεις)
4,3
4,3
Avatar Χρήστη
Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satisfied client. I am regularly doing following kind of tasks: Needing a script coded to take data from an existing Excel sheet and make a few changes to one Column. Thanks.
$100 USD σε 3 ημέρες
5,0 (18 αξιολογήσεις)
4,0
4,0
Avatar Χρήστη
I can provide you my full support and help you in Skype or Teamviewer from Monday to Friday 9:00 AM SGT - 6:30 PM SGT also...
$111 USD σε 2 ημέρες
4,7 (2 αξιολογήσεις)
1,9
1,9
Avatar Χρήστη
Can work In less time
$35 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I can do your project in two days. I had an experience in design such scripts. In my portfolio there is an example. Please check it out. If you have any questions, please ask)
$222 USD σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Please share more details on the project and then we can decide on the time frame to complete the task.
$200 USD σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Hello, I can probably develop a .NET application using C# to manipulate the Excel file as you described. Since you want to use the tool on Windows 2008 server, the target of the application will be .NET framework 2.0. However, I need more details about the drop-down menu where you will enter the replacement texts. If you like, we can chat to see if I can help. Thanks
$250 USD σε 5 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I believe in providing quality work with strict adherence to work ethics including 0 plagiarism and meeting deadlines. I am an MBA and have catered 500+ clients across USA, UK and Australia in academic, blog and content writing. I am a professional and experienced writer with thorough knowledge of different styles of writing like APA, MLA, Harvard etc. I will be glad to attach files of my previous work for your kind persual. Looking forward to discuss the project with you. Cheers!!
$233 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
lets do it bro *-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-*
$150 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Irving, United States
5,0
2
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιουλ 28, 2018

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.