Build Excel macros that can format 3 sets of spreadsheets (2 in each set) and produce new files that match specifications

Completed Posted Feb 11, 2015 Paid on delivery
Completed Paid on delivery

I need three different macros built into a blank spreadsheet or 3 separate spreadsheets if that's not possible. Each macro will have a way to select a file from my computer, format the file based on my specifications, and produce a new version of the file that is saved to the same folder directory. The new file will have the same file name as the original plus the word "FORMATTED" appended to the filename.

Macro 1

Instructions on how to format the files are provided in file named "CD1_A Form [login to view URL]". The macro will format the original files, named [login to view URL] AND [login to view URL], and produce a file that looks like the final product, which are files named [login to view URL] AND [login to view URL]

Macro 2

Instructions on how to format the files are provided in file named "CD3_B Form [login to view URL]". The macro will format the original files, named [login to view URL] AND [login to view URL], and produce a file that looks like the final product, which are files named [login to view URL] AND [login to view URL]

Macro 3

Instructions on how to format the files are provided in file named "CD3_C Form [login to view URL]". The macro will format the original files, named [login to view URL] AND [login to view URL], and produce a file that looks like the final product, which are files named [login to view URL] AND [login to view URL]

Excel Visual Basic

Project ID: #7127792

About the project

32 proposals Remote project Active Feb 12, 2015

Awarded to:

zExcel

Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions

$275 USD in 3 days
(257 Reviews)
7.7

32 freelancers are bidding on average $321 for this job

P0L

Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$300 USD in 2 days
(492 Reviews)
8.0
Vlzinch

Hi ! I work at international bank as credit analyst, so i work a lot with raw data. I can make this macro asap, and as new on this site, i"ll make it for low price. Regards, Vlad Zinchenko

$277 USD in 3 days
(67 Reviews)
7.7
alekscoder

Hi, I can do this job for you. I had done many similar jobs already. It can be done very quickly. Regards, programmer Aleks

$250 USD in 1 day
(89 Reviews)
6.2
adityasl

A proposal has not yet been provided

$250 USD in 3 days
(142 Reviews)
5.4
nagybatonyi

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contain More

$250 USD in 3 days
(64 Reviews)
5.7
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have bee More

$500 USD in 5 days
(19 Reviews)
5.7
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this reg More

$333 USD in 5 days
(45 Reviews)
5.6
tomislav1975

See my portfolio and reviews, contact me if you're interested. Thanks____________________________________

$300 USD in 5 days
(34 Reviews)
5.3
boriscikotic

Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: P More

$400 USD in 7 days
(28 Reviews)
5.3
abdolah2014

HI I am an excel-vba Expert and I can will finish your project so fast pm me ,,,,,,,,,,,,,we can discuss on the price too :) I am ready to start now pm me ............................................................. More

$250 USD in 5 days
(38 Reviews)
5.3
serdaryalcin

I have completed several projects like this one. I am working as consultant for an insurance company and I have completed many projects like this one. Reading CSV files, connecting them, is what I do.

$250 USD in 2 days
(25 Reviews)
4.6
prabakarm23

Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Serv More

$277 USD in 5 days
(54 Reviews)
4.7
vietcompro

A proposal has not yet been provided

$555 USD in 10 days
(22 Reviews)
4.2
sreejithakaz

I have over 9 years of experience in Excel, Access and Outlook VBA. I have developed several Tools, Automation, Dashboard, Database CRM and Online Extraction Tools using VBA. I have done a similar kind of project fo More

$277 USD in 10 days
(14 Reviews)
4.1
morrisstarling

If only all employers had your level of articulating requirements! My proposition: 3 macros in one file, a small dashboard where you can specify folders if they are fixed or open a filedialog window for you to select More

$300 USD in 4 days
(7 Reviews)
3.6
mubarakahmedacca

a b c f g f g f g fg d g d g g d f g g f d d f f g f fr r e e d fg g g g f f f f f df d d d d d d d d d d d d d d d d d

$555 USD in 10 days
(3 Reviews)
2.3
petrovp

Good day, I can write these three macros for you which will format the original files in accordance with your specifications.

$250 USD in 3 days
(5 Reviews)
2.8
Suchit123

hello employer i have exp of handling csv files programatically i can provide you the complete work in 1 day time i can do this task for around $150 plz message me for further communication

$250 USD in 1 day
(0 Reviews)
0.0
TopshelfAK15

Sir, I've already completed your project. If you award the bid I'll upload the workbook to you as soon as I can (within 8 hours of receiving your message). I expect you'll find no defects, but if you do I'll fix them A More

$333 USD in 1 day
(0 Reviews)
0.0
alaamokhtar

A proposal has not yet been provided

$277 USD in 7 days
(0 Reviews)
0.0