Medium to Complex Excel Macro (compatible with PC Excel 2003 coding)
$30-250 USD
Paid on delivery
We have a few medium to complex excel macro (depending on your level of Excel Expertise) that needs to be created or modified based on our existing macro.
Background:
Our macro parses data (3K rows+), and based on several macros, splits the data into worksheets and then does some minimal vlookup functions and similar functions and updates files (xlsx, xls and csv) files in a given set of directories.
Basically we need to update the values in a given path and mostly use vlookup to update values but there are bugs that we need fixing so that the CSV files retain the leading zeros on some of the columns.
We also need to simplify the process on how records are updated and have a " vba form" to retrieve macro settings instead of using worksheets which is used throughout the macro.
Requirements:
PC Microsoft Excel 2003 (Must be compatible with 2003 although we run most of our macros on 2010).This means you cannot use functions that are built for 2007+ excel.
We also require someone who is attentive to detail.
Lastly, if you only post you resume , we assume you did not READ the post. We want you to post how you can fix the above criteria regarding trailing zeros so the CSV retains the leading zeros yet when open in Excel , the file can update data based on the worksheets from the macro.
Project ID: #16692546
About the project
Awarded to:
I propose to force excel into retaining the leading zeros by adding apostrophes prior to the numbers which need to keep them, forcing excel into treating the cell as text Relevant Skills and Experience For the last co More
20 freelancers are bidding on average $145 for this job
Hello, I have the good knowledge of Medium to Complex Excel Macro (compatible with PC Excel 2003 coding) . I have more than 5 years of experience in Excel, Visual Basic, Visual Basic for Apps. We have worked on seve More
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. for removing trailing zeros and to retain leading zeros, I will write a smal More
Hi I read the details and I am wiling to do the task. I will tell you details in PM about the leading zero or anything else. I have 10 years experience with Data Processing in Excel and Web Researching. I work wi More
Hi, Leading zeros and other stuffs are not problem for me. Please send me the files, and provide as many details as possible. I have completed many similar projects, both here in Freelancer for several countries More
Hi I am an expert in VBA for Excel. I can do this project Can you please send me more details to estimate time? I can take lowest budget Also check my ratings and reviews Regards
I could do it for less, I could do it in less time as I am just here to find more challenging work. *********************************************************************************************************
I am B school passout,working as a senior consultant with a fortune 500 company,looking for freelancing projects. Relevant Skills and Experience I have done complex financial modelling in excel sheets.
I work for Amzon for last 5 years as analyst and love to work with Macros and Excel. Would deliver the project based on the deadline by the project owner