Find Jobs
Hire Freelancers

Excel Manipulation

$30-250 USD

Preklicano
Objavljeno pred več kot 5 leti

$30-250 USD

Plačilo ob dostavi
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
ID projekta: 17623959

Več o projektu

29 ponudb
Projekt na daljavo
Aktivno pred 6 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
29 freelancerjev je oddalo ponudbo s povprečno vrednostjo $131 USD za to delo
Avatar uporabnika
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 v 3 dneh
4,9 (353 ocen)
8,0
8,0
Avatar uporabnika
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 v 1 dnevu
5,0 (125 ocen)
6,5
6,5
Avatar uporabnika
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 v 3 dneh
5,0 (173 ocen)
6,2
6,2
Avatar uporabnika
- 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 v 4 dneh
4,7 (51 ocen)
6,0
6,0
Avatar uporabnika
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 v 1 dnevu
5,0 (35 ocen)
5,3
5,3
Avatar uporabnika
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 v 3 dneh
5,0 (30 ocen)
5,4
5,4
Avatar uporabnika
Hello sir, I am interested in your project. I would like to discuss details via pm. Yours sincerely,
$49 USD v 3 dneh
5,0 (25 ocen)
5,1
5,1
Avatar uporabnika
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 v 3 dneh
5,0 (24 ocen)
5,0
5,0
Avatar uporabnika
I am very able to create a excel macro to suffuce your requirement. I am ready to start.
$156 USD v 2 dneh
4,6 (45 ocen)
5,5
5,5
Avatar uporabnika
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 v 1 dnevu
4,9 (63 ocen)
4,7
4,7
Avatar uporabnika
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 v 3 dneh
5,0 (31 ocen)
4,5
4,5
Avatar uporabnika
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 v 1 dnevu
4,9 (6 ocen)
4,3
4,3
Avatar uporabnika
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 v 3 dneh
5,0 (18 ocen)
4,0
4,0
Avatar uporabnika
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 v 2 dneh
4,7 (2 ocen)
1,9
1,9
Avatar uporabnika
Can work In less time
$35 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Please share more details on the project and then we can decide on the time frame to complete the task.
$200 USD v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 5 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
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 v 3 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
lets do it bro *-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-*
$150 USD v 3 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
Irving, United States
5,0
2
Plačilna metoda je verificirana
Član(ica) od jul. 28, 2018

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.