ADVANCED: VBA

Dear Employer, Hope you are safe from Corona issue across Globe!! I understand you on a big hedge fund and you need a tool in which you will feed some word (like the reference numbers you mentioned) and you want the tool to find in which row it is present, return that row number, delete the reference number you mentioned and also do some white spacing ahead and behind that. I would request to give me this opportunity to work with you. I am already building the code that you asked, it will take some more time. Please message me meanwhile so that we can atleast start the discussion. You can also check my reviews, I will be among top 5 bidders. Hope to get revert soon!! Thanks and Regards, Ashish

Hello, I can help you with your project - ADVANCED: VBA I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

Hi This is Chandra. Expert in Excel advanced formulas and VBA Programming. Please refer to my review of the quality of work that I delivered to the clients across the globe. My bid based on 100 USD per hour (Awesome payment for the job) based on the project description. I would like to discuss payment schedules. I have referred the specifics of filtering the text and reporting the required outputs. Can you please share more insight of the data to capture? I would like to discuss with you briefly the specific requirements of the macro tasks last long for 4-5 months as specified in the description. Also, I can discuss via video call and screen sharing to debug the code and update it when necessary. Looking forward to work on the project. -Chandra

Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

Hello, I am a financial expert and guru in Excel with extensive knowledge and expertise in advanced formulas, pivot tables, tables, solver and visual basics including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting and importing databases and create automation with VBA. My modules allow filling information on forms (with drop-down list ), manipulating and merging info into structured tables and populating results in built-in reports and forms. There is a search engine with high search capability to find specific records. During the process, Excel validates the information and prepare graphical and visualisation reports and documents based on needed parameters and criteria. There is a report generator which enables you to develop templates independently. The modules are secured by username login and password. Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, long term debts, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic and designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.

Hi, I will make Visual Basic code to make your daily work easier as per your requirement with good and professional quality without any error. Need to discuss more before start. I have completed more then 150 project within 11 months with 5 star review. You are gentle requested to see excel project sample in my portfolio here: https://www.freelancer.com/u/rashedkhanrubel. I will deliver the project within timeline with better quality. If you want to award me the project I'd be very happy to discuss deeply about your requirement and get started for you as soon as possible. Thanks! Rashed

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred and twenty five excel vba projects in couple of years. Willing and looking forward to working with you. Thank you, Regards.

I can perfectly help you in developing an automation Excel based tool to perform this. I am a professional VBA programmer, Financial Analyst and Excel expert holding years of experience.

Hello, I am an independent, experienced excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

Hi, Keen to work on this project. With my extensive experience on Excel VBA I can bring in desired level of automation and can handle the complexity of Advanced level of VBA. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Google maps, sending email through Outlook, Image handling, Userforms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 20 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks

£ 36/hr Only ------- I can make you the VBA Macro Program to automate your manual work of your complicated file by maintaining 100% accuracy of your data absolutely as you want ------- Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5* ratting. I can start right now, please message me to discuss more.

Hello I am VBA developer for the past 10+ years and have implemented lots of projects here in freelancer. I can get you all sorts of automation needed for solving your troubles. Do ping me more details if you are interested. Thanks Gokul

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of manipulating strings, searching text in large string etc. I have done mostly Excel VBA Programming jobs. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will write for 4-5 months

I am a full time freelancer providing automation consultancy to SME / MSME companies . Please find below a brief introduction of myself. I am postgraduate (MBA) in Finance having more than 7 years of experience in Financial modeling, credit analysis, automation consultancy, advanced excel based tools, VBA automation, dynamic dashboards, google spreadsheets, google scripting, and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst & Young and Landmark Group also. You can get your work done here with highest quality at lowest price . Please initiate a chat so we can discuss on this as I may have some questions. Looking forward to work with you

I'd like to be considered for your request. I am a data guy with a strong background developing several excel tools including vba automation and complex formulas and functions applied in excel and I can assure quality and accuracy in a short time based on your request. For more than 10 years i've worked on different sets of files having to deal with a lot of complex projects. I have a deep passion to finish in time every project that i am involved in. You can see my profile for better understanding what i was involved with. I highly evaluate professionalism and hold my self strictly accountable to fulfill my client need. I aim to form a great working relationship. Thank you for your consideration. Martin

Hi, I can participate in your project. I did not get the sample part that you need, but I can provide any sample file so if you are interested in we could have quick chat about details and your requirements. I have rich experience in VBA-Macro(Excel, Powerpoint, Access, Word, Web scrapping, API, ....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin

Hi, I'm an expert application software developer, with significant experience in VBA, and developing spreadsheet and text processing applications for Windows. I am confident that I can do this job for you, and am interested in being your long-term "go to" data and programming consultant, for all your data projects and work. I'm located in Malawi (south eastern Africa) , and am available for work during UK working hours. Good quality, reliable work done, and long term support service offered. Thanks for considering my bid. Best wishes, Steve ~ Larry Anselof Technology Solutions - Providing a quality and reliable freelance software development service since 2004 ~

Hi there, I believe I can help you on your project. I have excellent knowledge of Excel VBA and can write complex functions. I have a couple of questions about the function you want. *. Do you want to pass the word "Ref" or Ref number like "015f4115". *. If it is the word "Ref" then should it return first matching row as I can see from your description ? If you can specify the requirements then I can send you code for testing on your side. Please feel free to contact via chat for further discussions. Looking forward.

Dear Client, I have strong VBA skill and I can write a function as you have mentioned passing message and defining the required field and it just returns the field data. For example if you call function as follows it will retrun 015f4119 ? GetMessagePart("Trade = 2357 Order =. 16:58 Equity = Coca Cola Inc. User =. Boris Johnson Ref = 015f4119", "Ref") Furthermore, there is DOT after equal sign on Order and User field, is it a typing error or data is as it is? Thank you, Regards, Shiv