Find Jobs
Hire Freelancers

VBA Excel maco

$10-30 AUD

Concluído
Publicado há mais de 4 anos

$10-30 AUD

Pago na entrega
Update VBA macro to first interrogate header column of data file to determine column contents. Macro currently assumes data source columns in fixed order. Macro uses 6 columns of much larger data table. Sometimes data table output columns change order but they always have the same header. We want to improve the macro to first interrogate the data column header for a "key" label to determine the contents of the column, rather than assuming a fixed column order in the data. If the source data columns change order, then the improved macro will still select the correct column for processing based upon the column header key. I have uploaded the current MACRO and the TEST DATA so you can estimate the time required.
ID do Projeto: 22258794

Sobre o projeto

20 propostas
Projeto remoto
Ativo há 4 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Greetings! I have reviewed the code and the input and output file formats. The macro currently assumes the exact column No. for the following fields - Date, Policy Id, Src Ip, Dest IP, RecvBytes, SentBytes and External. I can update the macro such that the column numbers for the fields of interest are determined at run time (thereby allowing different input formats as long as the columns of interest are present in input file). Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 20 years experience in using Excel as part of my daily work life. Over the last 30 MONTHS , I have spent at least 200 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$25 AUD em 1 dia
5,0 (205 avaliações)
6,9
6,9
20 freelancers estão ofertando em média $34 AUD for esse trabalho
Avatar do Usuário
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. I can make the adjustment, and also improve some other sections of the code that are not working in the best way. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$35 AUD em 1 dia
4,9 (243 avaliações)
7,0
7,0
Avatar do Usuário
Hello I have several years of experience with Visual Basic and Excel Macros Also, I am familiar with technique to interrogate header column.
$23 AUD em 1 dia
4,9 (369 avaliações)
6,5
6,5
Avatar do Usuário
Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not bid on projects which I am not sure. I will not disappoint you and I will do my best for give you a perfect solution. If I have an opportunity to work with you, That's my pleasure. No milestones required in advance, please pay me once the job is 100% complete. Also, before you consider awarding me the project, I can provide you with some sample files via your requirements. Please message me, so we can discuss here as I may have some questions. Thank you. Marko R.
$30 AUD em 1 dia
4,9 (46 avaliações)
5,7
5,7
Avatar do Usuário
Hi, I can improve your macro. I've got the solution for your file. I have grear skills and experience in VBA Macro excrl. Let's have chat for more detailed discussion.
$30 AUD em 1 dia
5,0 (40 avaliações)
4,9
4,9
Avatar do Usuário
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$60 AUD em 2 dias
4,8 (32 avaliações)
5,0
5,0
Avatar do Usuário
Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ ⭐⭐⭐⭐⭐ waiting your answer Regards
$30 AUD em 1 dia
4,9 (61 avaliações)
4,7
4,7
Avatar do Usuário
Hi there, I can rewrite or modify the existing that can copy data from one sheet to another based on header columns Please message me if this is any of what you need. I’ll be standing by to help. Reggie
$30 AUD em 2 dias
5,0 (17 avaliações)
4,7
4,7
Avatar do Usuário
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this because of my project experience with VBA. If interested, we can discuss this further on chat.
$30 AUD em 1 dia
4,9 (12 avaliações)
4,1
4,1
Avatar do Usuário
Hi there! I read your description. I can make this done in very short time! I am ready to start work right now. i can do this work easily. IF you are interested to work with me message me.
$25 AUD em 1 dia
4,8 (17 avaliações)
3,7
3,7
Avatar do Usuário
Hi. I have read your project details and sure to deliver your project requirements. I have 5 years of experience in excel macros. I have also looked at the attachment. I am available to start the work now and deliver in one day. Contact me for more information. Thanks in advance.
$20 AUD em 1 dia
4,7 (16 avaliações)
3,7
3,7
Avatar do Usuário
Hi. Sir Thanks for your post. I am interested in your project. I am a expert who have many experiences in Excel, Vba If you hire me, I can complete this project in short time as you want. I can start working right now. Regards,
$20 AUD em 7 dias
5,0 (3 avaliações)
3,1
3,1
Avatar do Usuário
G’day, I am interested in this project. I am basically a Software Engineer by profession with over 8 years of experience in VBA development. I can complete this project in 2 days. (1st day I will give you an update, the second day is just for a revision if you want any more changes ). I am new to Freelancer, but the VBA concepts are very old to me. Please give me an opportunity to work with you and I will prove to you, your choice was right. In case my deliverables are not up to your standard, then no need to pay me anything, no questions asked. Kindly ping me, so that we can discuss further in detail. I will also tell you the method I will be using to complete the task if you are satisfied with my approach, then you can award me this project. Regards, Ritesh Hegde
$20 AUD em 2 dias
5,0 (5 avaliações)
2,3
2,3
Avatar do Usuário
Hello! I am VBA expert with 5+ year experience. I have good experience of lots of project in excel,access,outlook,word,power point, web scraping, manipulate data, linking to SQL Server and read data from PDF files. I am expert in automation. If you are looking for true Freelancer. I am right person for you. I am available 24-7 and very responsive. I promise to deliver 100% satisfaction. Please check my profile and contact me to discuss further details. I would like to help you with your project. Regards and Thanks VBA expert- Mintu Kumar
$13 AUD em 2 dias
5,0 (4 avaliações)
1,7
1,7
Avatar do Usuário
Hi, if your file has header, a macro can be wriiten to rearrange the columns into your desired order or extract to a sheet. However your sample data file ha no header Let us discuss over chat
$40 AUD em 4 dias
5,0 (3 avaliações)
1,7
1,7
Avatar do Usuário
Hello, I read your project description and understand all. I have rich experience in Excel Formulas, Excel VBA /macro. I will make the perfect product that you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.
$20 AUD em 1 dia
5,0 (1 avaliação)
0,0
0,0
Avatar do Usuário
Assured required output within stipulated time duration. Sample output will be available free of cost upon confirmation of deal.
$15 AUD em 2 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) AUSTRALIA
Sydney, Australia
5,0
2
Método de pagamento verificado
Membro desde fev. 4, 2019

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.