Find Jobs
Hire Freelancers

VBA Excel maco

$10-30 AUD

已完成
已发布超过 4 年前

$10-30 AUD

货到付款
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: 22258794

关于此项目

20提案
远程项目
活跃4 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在1天之内
5.0 (205条评论)
6.9
6.9
20威客以平均价$34 AUD来参与此工作竞价
用户头像
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 在1天之内
4.9 (243条评论)
7.0
7.0
用户头像
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 在1天之内
4.9 (369条评论)
6.5
6.5
用户头像
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 在1天之内
4.9 (46条评论)
5.7
5.7
用户头像
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 在1天之内
5.0 (40条评论)
4.9
4.9
用户头像
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 在2天之内
4.8 (32条评论)
5.0
5.0
用户头像
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 在1天之内
4.9 (61条评论)
4.7
4.7
用户头像
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 在2天之内
5.0 (17条评论)
4.7
4.7
用户头像
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 在1天之内
4.9 (12条评论)
4.1
4.1
用户头像
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 在1天之内
4.8 (17条评论)
3.7
3.7
用户头像
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 在1天之内
4.7 (16条评论)
3.7
3.7
用户头像
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 在7天之内
5.0 (3条评论)
3.1
3.1
用户头像
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 在2天之内
5.0 (5条评论)
2.3
2.3
用户头像
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 在2天之内
5.0 (4条评论)
1.7
1.7
用户头像
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 在4天之内
5.0 (3条评论)
1.7
1.7
用户头像
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 在1天之内
5.0 (1条评论)
0.0
0.0
用户头像
Assured required output within stipulated time duration. Sample output will be available free of cost upon confirmation of deal.
$15 AUD 在2天之内
0.0 (0条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
Sydney, Australia
5.0
2
付款方式已验证
会员自2月 4, 2019起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。