Background : Aim to create programs to extract, validate and transform input data in various excel sheets into final formats so as to create meaningful dashboards
Objective: Write VBA macros as per expected outcomes and suggested logic explained below.
Scope: Following macros to be created. Macros need to be modular with comments so that they can be understood easily
1. To list down all input fields in various database (to be provided) along with no. of rows, unique - duplicates, blanks-non blanks
2. Based on validation and conversion logic, create new database (template provided) based on input data
3. Generate discrepancy report that checks the data for errors (based on validation logic)
23 freelancers are bidding on average ₹11332 for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. Willing to take up your project. Thank you, Regards.
I have a lot of experience using MS Excel and VBA. I have been business consultant for more than 15 years so I understand technical and business side of this requirement.
I have done MSc in Computer Science and Information Technology.I have worked in an IT firm for 4-5years .I have worked with VB,MS Office and im passionate with my work. Thanks
I have over 14 years of rich experience in VBA Excel/Advanced Excel/ MS Access/ Word, VB.net/ VB6/ SQL Server/sqlite. I am a FULL TIME freelancer Please send details