Medium to Complex Excel Macro (compatible with PC Excel 2003 coding)

Completed Posted 5 years ago Paid on delivery
Completed 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.

Excel Visual Basic Visual Basic for Apps

Project ID: #16692546

About the project

20 proposals Remote project Active 5 years ago

Awarded to:

danluckingdl

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

$111 USD in 3 days
(4 Reviews)
3.2

20 freelancers are bidding on average $145 for this job

schoudhary1553

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

$250 USD in 5 days
(339 Reviews)
8.0
paris2785

Hello! My name's Paris Pallas and I'm among the most experienced and successful Excel developers on this platform. I don't want to talk about myself but rather leave my work do this for me. Feel free to visit my por More

$150 USD in 7 days
(250 Reviews)
7.5
Tanmoy236

I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business More

$150 USD in 3 days
(251 Reviews)
6.9
watersev

hi there, I have a vast experience in Via and Excel and will be happy to help you on the project. Best regards, Eugene PS. There are different approaches to retain leading zeroes. one of them is to set text number fo More

$111 USD in 1 day
(262 Reviews)
6.5
periyannas

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

$200 USD in 4 days
(113 Reviews)
6.4
vlayausa

Hello, I am proficient with Excel and VBA. I would love to help with this project. Leading zeros would be solved by setting the column format to text before importing CSV. Please contact me for more inform More

$123 USD in 3 days
(139 Reviews)
5.8
rumarahman

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

$150 USD in 3 days
(39 Reviews)
5.1
serdaryalcin

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

$100 USD in 5 days
(21 Reviews)
4.4
chintuag

Dear Hiring Manager, I have worked on several projects in Excel. The trailing zeros could be saved by counting it how many are they and then in the end concatenate them to retain it in the csv file for each record. More

$210 USD in 5 days
(10 Reviews)
4.0
shaarawi

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

$35 USD in 3 days
(9 Reviews)
3.2
simonmolinam

A proposal has not yet been provided

$222 USD in 3 days
(0 Reviews)
0.0
Clandestine12212

I could do it for less, I could do it in less time as I am just here to find more challenging work. *********************************************************************************************************

$111 USD in 2 days
(0 Reviews)
0.0
Ramanujamarun

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.

$155 USD in 3 days
(0 Reviews)
0.0
vijitgpt123

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

$155 USD in 3 days
(0 Reviews)
0.0
GeorgeVBA

With the trailing zeros I would look for contiguous data and then clear the data below the end of the contiguous data. Another option would be to look at the loop that is creating the data and see if I could prevent th More

$166 USD in 5 days
(0 Reviews)
0.0