Đã hoàn thành

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.


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.


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.

Kĩ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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

Về Bên Thuê:
( 1 Nhận xét ) Twentynine Palms, United States

ID dự án: #16692546

Được trao cho:


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 Thêm

$111 USD trong 3 ngày
(1 Nhận xét)

22 freelancer đang chào giá trung bình $146 cho công việc này


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 Thêm

$250 USD trong 5 ngày
(251 Nhận xét)

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 Thêm

$111 USD trong 1 ngày
(249 Nhận xét)

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 Thêm

$150 USD trong 7 ngày
(144 Nhận xét)

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 Thêm

$150 USD trong 3 ngày
(129 Nhận xét)
$155 USD trong 1 ngày
(52 Nhận xét)

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 Thêm

$123 USD trong 3 ngày
(130 Nhận xét)

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 Thêm

$150 USD trong 3 ngày
(30 Nhận xét)

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 Thêm

$200 USD trong 4 ngày
(38 Nhận xét)

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. Thêm

$155 USD trong 3 ngày
(22 Nhận xét)

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 Thêm

$200 USD trong 6 ngày
(53 Nhận xét)

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 Thêm

$100 USD trong 5 ngày
(21 Nhận xét)

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. Thêm

$210 USD trong 5 ngày
(9 Nhận xét)

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 trong 3 ngày
(9 Nhận xét)
$55 USD trong 3 ngày
(0 Nhận xét)

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 trong 2 ngày
(0 Nhận xét)

A proposal has not yet been provided

$222 USD trong 3 ngày
(0 Nhận xét)
$155 USD trong 10 ngày
(0 Nhận xét)

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 trong 3 ngày
(0 Nhận xét)
$100 USD trong 5 ngày
(0 Nhận xét)

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 trong 3 ngày
(0 Nhận xét)