Excel Manipulation

$30-250 USD

Cancelled

Posted

over 5 years ago

$30-250 USD

Paid on delivery

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

Excel

Visual Basic

Project ID: 17623959

About the project

29 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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

29 freelancers are bidding on average $131 USD for this job

@schoudhary1553

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 in 3 days

4.9

(353 reviews)

8.0

@Attractionnet

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 in 1 day

5.0

(125 reviews)

6.5

@rashedkhanrubel

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 in 3 days

5.0

(173 reviews)

6.2

@satishtl

- 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 in 4 days

4.7

(51 reviews)

6.0

@khoddam

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 in 1 day

5.0

(35 reviews)

5.3

@MoohHHooM

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 in 3 days

5.0

(30 reviews)

5.4

@osmanaydin

Hello sir, I am interested in your project. I would like to discuss details via pm. Yours sincerely,

$49 USD in 3 days

5.0

(25 reviews)

5.1

@poduzov

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 in 3 days

5.0

(24 reviews)

5.0

@sonarkaushik

I am very able to create a excel macro to suffuce your requirement. I am ready to start.

$156 USD in 2 days

4.6

(45 reviews)

5.5

@Ahmed818

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 in 1 day

4.9

(63 reviews)

4.7

@jsb1156

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 in 3 days

5.0

(31 reviews)

4.5

@aminw

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 in 1 day

4.9

(6 reviews)

4.3

@Mfaisalshahzad00

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 in 3 days

5.0

(18 reviews)

4.0

@vramusg

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 in 2 days

4.7

(2 reviews)

1.9

@lirpa11

Can work In less time

$35 USD in 3 days

0.0

(0 reviews)

0.0

@dispet4er

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 in 2 days

0.0

(0 reviews)

0.0

@vermaamrit95

Please share more details on the project and then we can decide on the time frame to complete the task.

$200 USD in 2 days

0.0

(0 reviews)

0.0

@jdayyeh

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 in 5 days

0.0

(0 reviews)

0.0

@Esteemcoin1

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 in 3 days

0.0

(0 reviews)

0.0

@hashanchamikara

lets do it bro *-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-**-*-**-*

$150 USD in 3 days