Find Jobs
Hire Freelancers

Excel data manipulation tool - create an Excel macro or VB code to manipulate data

$10-30 USD

Complété
Publié il y a plus de 3 ans

$10-30 USD

Payé lors de la livraison
I am importing a large spreadsheet into a database Table. Some rows have more than one entry that I want to use as an index. Would like a Tool (VB, Excel Macro) to format all cells as text and to split the 'problem' rows so that they have a single entry. See attached spreadsheet example. Tool needs to be transferable between spreadsheets.
N° de projet : 27237560

Concernant le projet

18 propositions
Projet à distance
Actif à il y a 4 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day
$25 USD en 1 jour
4,9 (63 commentaires)
5,5
5,5
18 freelances proposent en moyenne $26 USD pour ce travail
Avatar de l'utilisateur
Hello, Are you importing the data into sql server database? If you want i can provide you a .Net based simple tool for this purpose. Looking forward to have a positive response from you. Thanks
$50 USD en 2 jours
5,0 (216 commentaires)
7,4
7,4
Avatar de l'utilisateur
Hi, I can help with Excel macro to create rows with unique CAS No and delete the [1], [2], [3], etc. Keen to work on this. Looking forward to your response. Thanks
$30 USD en 1 jour
4,9 (123 commentaires)
6,3
6,3
Avatar de l'utilisateur
start right away... read your project details and attachment . I can create an Excel macro or VB code to manipulate data by maintaining 100% accuracy of your data absolutely as you want. ------- I can start right now, please message me to discuss more. Regards, MA Hossain
$39 USD en 1 jour
5,0 (173 commentaires)
5,9
5,9
Avatar de l'utilisateur
HI there, I can create a amcro that will format all cells as text and to split the 'problem' rows . I’m an Excel VBA expert and have 7+ years of experince in creating complex automation tools, formulas, databases, queries and macros. Please message me to discuss more. Regards, ravinder
$20 USD en 1 jour
4,9 (44 commentaires)
5,0
5,0
Avatar de l'utilisateur
Hi I am VBA Developer Experianced In Web Scrapping & VBA Macros I can finish this task in a day only please share the details thanks
$30 USD en 1 jour
4,9 (45 commentaires)
4,8
4,8
Avatar de l'utilisateur
Hi, Good Day! I can help you building Automated tool using excel and vba macro. I can't open the attached file can you share it to me?. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. I also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$25 USD en 1 jour
4,9 (48 commentaires)
4,8
4,8
Avatar de l'utilisateur
Hi, I understood the data cleanup tool that you want. It will be a pleasure to complete this job. The tool can be easily applied to cleanup any workbook so long as the columns arrangement are same as in the sample spreadsheet and files found through the link. I will be a pleasure to work on this assignment and I hope that there will be an opportunity. Please feel free to message me any time. Thanks. Best regards
$20 USD en 7 jours
5,0 (5 commentaires)
2,9
2,9
Avatar de l'utilisateur
Hi there, I am an expert in excel formulas, dashboards, macros.I have gone through the description on your project and will be able to finish before the deadline. Thanks Jayant
$30 USD en 1 jour
5,0 (8 commentaires)
2,4
2,4
Avatar de l'utilisateur
Hi I can create list of unique CAS Nos as you specified in your sample sheet. Your requirement is very clear and I am sure I can code it and deliver in few hours Can you clarify my below doubt? Do you want to create the list of unique CAS No in another sheet or in the same sheet? If you want to create in same sheet then number of rows to inserted for each cell that has more than 1 CAS No. Hope you can clarify this. With my experience in VBA and Excel coding, I can support for early completion Let us start discussing to complete the project at the earliest. Advance Thanks for selecting me
$15 USD en 1 jour
5,0 (4 commentaires)
1,6
1,6
Avatar de l'utilisateur
Hi there, I have reviewed your project, my extensive knowledge in the subject area is an assurance of quality and original work that covers all your instructions Fast and accurate typing,Typing from handwritten notes Power Point Presentations,Excel Worksheets (with formulas) PDF to editable files. a) Fast and accurate typing b) Typing from handwritten notes c) Power Point Presentations d) Excel Worksheets (with formulas) e) PDF to editable files g)Developing complex tables/graphs Thanks for your Time. MUHAMMAD
$10 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
hello, i understand your requirements, you need a macro to format cells and to split data to another wherevr required, let me knw if you can give an opportunity to work for you.
$10 USD en 2 jours
0,0 (0 commentaires)
0,2
0,2
Avatar de l'utilisateur
I’m Ahmed Hassanein. I have over 20 years’ experience supporting systems and users in information technology field such as office applications, domain servers, application servers, network security, information systems audit ... etc. I’ve been working with Excel since the 90’s as a user, a Developer and a Trainer. I have excellent Excel skills that enabled me to do my work in an accurate and fast way.
$20 USD en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Good day! I have the necessary skills to process data using VBA Excel. In my work, I use modules of classes, user forms, standard modules as needed. I am fluent in the basic means of the VBA language, when writing code I actively use collection objects and dictionaries. Skill in processing xlm and html tree structures using built-in Microsoft libraries, experience in parsing data using regular expressions, experience in processing PDF data using VBA, processing and embedding graphical objects on Excel sheets, batch processing of data from two or more books, outputting Excel tabular data to Word files template. Currently more than 650 freelance jobs
$20 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I can assure you that i can finish my job on time and also that is 100% correct and well-created. Relevant Skills and Experience Visual Basic
$25 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Sir I am very confident about this job .
$15 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hello, I can write You a macro to split any chosen column by the new line character, deleting anything in brackets. You could use that for any further work. I have done such things several times, converting Oracle reports to proper data 'understandable' by Excel or Access. Regards, Andrzej Ciupiński
$26 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
Baton Rouge, United States
0,0
0
Méthode de paiement vérifiée
Membre depuis déc. 16, 2019

Vérification du client

Autres travaux de ce client

Database update
$15-25 USD / hour
Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.