Lengkap

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.

Kemahiran: Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: excel 2010 vba find records month, expertise macro coding excel, excel data form macro, 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, macro task outlook 2003, macro copying conten excel file, macro copy part cell content excel, macro excel web form, copy data paste anther excel file macro, macro find data copy cell excel, excel file macro asp excelapplication, macro move contents cell cell excel, macro copy paste excel file, excel 2003 toolbar excel 2007, solidworks macro excel file, macro convert dat file excel file, macro update log files status excel sheet, macro move data cell database excel

Tentang Majikan:
( 0 ulasan ) STANTON, United States

ID Projek: #16692546

Dianugerahkan kepada:

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 Lagi

$111 USD dalam 3 hari
(0 Ulasan)
0.0

26 pekerja bebas membida secara purata $155 untuk pekerjaan ini

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 Lagi

$250 USD dalam 5 hari
(223 Ulasan)
7.3
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 Lagi

$111 USD dalam sehari
(245 Ulasan)
6.3
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 Lagi

$150 USD dalam 7 hari
(134 Ulasan)
6.6
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 Lagi

$150 USD dalam 3 hari
(117 Ulasan)
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 Lagi

$123 USD dalam 3 hari
(125 Ulasan)
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 Lagi

$150 USD dalam 3 hari
(29 Ulasan)
4.9
$155 USD dalam sehari
(31 Ulasan)
5.4
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. Lagi

$155 USD dalam 3 hari
(21 Ulasan)
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 Lagi

$200 USD dalam 6 hari
(52 Ulasan)
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 Lagi

$100 USD dalam 5 hari
(21 Ulasan)
4.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 Lagi

$200 USD dalam 4 hari
(23 Ulasan)
4.6
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. Lagi

$210 USD dalam 5 hari
(9 Ulasan)
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 dalam 3 hari
(9 Ulasan)
2.8
syazwanitohir

Hi! I feel I am suitable for this job as I have a great deal of experience in making and writing CLEAN, EFFECTIVE excel . As your expectation to be great in your particular task given, I will make sure it follows the Lagi

$168 USD dalam 3 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0
$100 USD dalam 5 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
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 dalam 2 hari
(0 Ulasan)
0.0
$155 USD dalam 10 hari
(0 Ulasan)
0.0
$55 USD dalam 3 hari
(0 Ulasan)
0.0