Completed

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

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.

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: excel 2010 vba find records month, expertise macro coding excel, excel data form macro, open excel file from c++, c++ excel output, how to import excel into c++, c++ import excel, automating excel with c++, code project excel c++, writing excel file in c++, com interface c++ excel, excel, visual basic, visual basic for apps, microsoft excel, excel entry form macro, use macro download data yahoo finance excel, time script macro vba outlook 2003, macro sub directory file list excel, macro import multiple text files excel file automatically

About the Employer:
( 1 review ) Twentynine Palms, United States

Project ID: #16692546

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
(1 Review)
2.8

22 freelancers are bidding on average $146 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
(251 Reviews)
7.4
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
(249 Reviews)
6.4
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
(144 Reviews)
6.7
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
(129 Reviews)
6.2
$155 USD in 1 day
(52 Reviews)
6.1
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
(130 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
(30 Reviews)
5.0
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
(38 Reviews)
5.0
AndrejStastny

Hi I'm excel and VBA expert.I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. More

$155 USD in 3 days
(22 Reviews)
5.1
Taisho

Hello, Because of how Excel works when displaying CSV files, it never shows leading zeros. But You can open the same file with notepad and You will notice that he zeros are there. That's why in case leading zeros ar More

$200 USD in 6 days
(53 Reviews)
4.8
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.5
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
(9 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)
2.8
$55 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
simonmolinam

A proposal has not yet been provided

$222 USD in 3 days
(0 Reviews)
0.0
$155 USD in 10 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
$100 USD in 5 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