flat file xls to create group automatically using vba or macro - Part 3 - 28/04/2018 12:37 EDT

thanks a lot sir . i will deliver the output as discussed.......... thanks a lot :)

Hello there, I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A

Hello. I can do your project in less than a day according to your description (with groups and with sub totals) with full delivery and without error. I would also complete your project with the highest precision and quality. I have extensive experience in Excel, Coding and Data processing.

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.

Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction.

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, chart, advance formulas, VBA etc. thanks

Dear Sir: It will be my pleasure to help you with the creation of the file as you have requested. I have Experience with automation of several kind of process with excel and vba. It would be great if you can share an example with me, so I can start figuring out a solution for you. Best Regards

Hi, My name is Marlou and you can call me Maloyski since this is the name they usually called me! Based on the description you provided, you want to excel macro to create grouping, with sub total and a UI design? I believed I can help you with this task. I have the experience to handle large systems and appilcation with decent user interface. Currently, I am using MS Excel VBA to create a company tools to monitor some task and transform source files like (csv, txt, excel) to xml format. I have 16 years IT experience which 10 years in vb6 and mssql database. Aside from vb6, I am currently a webMethods developer. You can find other technology I've used below for your reference. Just to manage your expectation, I am only part time developer here in upwork and I can work only 3 to 4 hours a day. If this is a problem for you, you can hire other freelancer that fits your needs and If my working hours is acceptable to you just let me know and I will help with your task. I don't have any portfolio added as of the moment since I am still new in upwork and hoping that you will be my first client Technology: Excel VBA - 3 years Ms Access VBA - 3 years vb6 - 10 years Mssql - 10 years Oracle - 5 years Crystal Report - 10 years AS400 - 3 years Java - 5 years xslt - 8 years webMethods - 8 years Systems Created: Billing System - vb6/msssql/crystal report Lending System - vb6/mssql/cyrstal report Accounts Receivable - vb6/mssql/cyrstal report Accounts Payable - vb6/mssql/cyrstal rep

Hi! I have experience working with Excel VBA, I can complete this task and for sure you will be satisfied with the final result! I have been working with a kind of code to make groups!

Hai I am good in excel and macros. I can do as per your requirement. Please provide me full details.

I am the best candidate for you because I have a consistent history of exceeding my targets and goals for the past three years. I have been working for the last two years in this field which makes me the best candidate for this job. I have cold calling skills which I will put to work immediately after you accept my proposal for this project.

This project sounds right up my alley. I have a passion for excel and VBA and I could easily create what you are asking for. I am also trying to build my profile on this site and would like to be awarded this project. I guarantee accuracy and timeliness.

Good 10+ years of experience in using excel, VBA and Macros. All these experiences are from IT Company in creating Excel and extraction of data from Excel.

Hello! I am new to Freelancer, so I don't have any reviews yet, but your project is one that I know I can excel at! I have extensive experience in Python and automating moving data from one excel file to another and putting the data in the specific places you would like. I have worked as a research assistant at a major university and have created many programs to quickly (think seconds) transfer data from 1000s of files into one masterfile. In once case I automated a process that was taking a co-worker months to complete (transposing data from many sheets into one sheet) and I did it all in a day! This kind of project is something I routinely do in my work, so it would be easy for me to complete your project! I have a few questions: 1. How many files will be required? 2. What is the exact timeline for this posting? I hope to hear from you soon!

For this demand I propose to use: Vba; Named Tables; Pivot table; Functions of logic, identification and data search;

* Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance. * Proven background completing projects under financial and time constraints. * Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries. * Develop GUI interfaces with progress bars and status label to intimate the user about background process. * Creating Data validation on inputs to reduce the complexity and runtime errors. * Accessing and developing customized solutions for clients/users. * Designed and wrote the automation code for Excel/Outlook/Power point and Access database queries and resolution.