Create an Excel Macro VBA to Achieve Desired Formatting of Data

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

We are a sport, health and wellness facility. To produce our seasonal program guides, we export an Excel file containing all our programs for a particular season. However, to bring the program it into Adobe InDesign so that it automatically populates the design file, the excel file is not in the correct format. We are looking to have an Excel Macro created that will reformat the data into the correct format.

In the file attached, Sheet 1 will show you an example of the data we receive in the original excel file and in Sheet 2 an example of the correct formatting required.

Data Entry Data Processing Excel

Project ID: #11535352

About the project

22 proposals Remote project Active 7 years ago

Awarded to:

satishtl

I can have the data formatted using Macro in the correct format as specified. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Please review my portfolio on recent proje More

$50 CAD in 1 day
(51 Reviews)
6.2

22 freelancers are bidding on average $91 for this job

tiaratechies

Hello, I am experienced and qualified in excel programming and macros. As i am new to freelancer if given an opportunity will deliver the best in given time frame. Thank you & regards Techies

$30 CAD in 3 days
(103 Reviews)
7.5
Teloquence

EXCEL/VBA expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that i can start with the implementation.

$100 CAD in 0 days
(339 Reviews)
7.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$100 CAD in 1 day
(306 Reviews)
7.3
ksriniravi

Attachment Missing! Please add the files...I would revisit the quote once files are added. Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot More

$80 CAD in 1 day
(217 Reviews)
7.0
zebracaro

I can do it for you quickly and exactly.

$90 CAD in 1 day
(120 Reviews)
7.1
aarifakhtar

Hi: Please note that over 90% of my completed projects are related to Excel and Macro. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss your requirements in detai More

$60 CAD in 1 day
(179 Reviews)
7.2
sajibdigital

***** Hello, I would like to complete your project. Please reply to me on PM for more discussion. If you want to know about my experience, Please visit -https://www.freelancer.com/u/sajibdigital.html Thanks, More

$50 CAD in 3 days
(75 Reviews)
5.8
vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. Please contact me for more information.

$86 CAD in 2 days
(142 Reviews)
5.9
sorinacho88

Hello, I can create the macro for you. If you are interested please open a chat with me. Kind regards, Sorin

$55 CAD in 3 days
(61 Reviews)
5.4
nineoneone

Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if y More

$50 CAD in 2 days
(21 Reviews)
4.7
arpankumarde

Hi, I am good and fast in excel. Can I see the original file? There was no attachment in the project. Thanks, Arpan

$55 CAD in 3 days
(64 Reviews)
4.5
eskemar

Dear please give me the chance to work for you I have good computer skill and I have been through Excel, Data entry, web search and web scraping for many years and this is my first time on this site and hence you can More

$100 CAD in 3 days
(14 Reviews)
3.9
Virend7586

Hello, My name is Virendra Meshram. Our potential to work and provide the best quality service requirements. I have a lot of knowledge of this task. I can do this work very fast & I understood this project. I can st More

$155 CAD in 3 days
(17 Reviews)
3.8
jejkop

Hello, This kind of task is the part of my everyday job (I'm a MS Office's trainer and support). I'm a specialist in this domain and this work will be done very good. I can manage this for you and I'm sure that our More

$50 CAD in 0 days
(2 Reviews)
2.0
steve2022

Hi there! I am confident that I can complete this macro for you within 24 hours. I will need you to re-upload those files you mentioned in your project as they don't appear to have been successfully attached. I'm an Au More

$150 CAD in 1 day
(4 Reviews)
2.1
ArtiomLt

EDITED: Hello, I'm an Excel VBA developer with over a year of experience in this field. I must inform you that there is no file attached, so it's difficult to tell something about this project. Could you please send me More

$35 CAD in 1 day
(0 Reviews)
0.0
rama280892

I would be able to complete the task in the maximum of 2 days. I could deliver 100% of quality work as I have experience in excel for 5 years and I would able to process it quickly. Satisfaction on my work has become t More

$177 CAD in 3 days
(0 Reviews)
0.0
sallabadi

I am interested in applying for your job posting. I have extensive experience with Excel automation, both using VBA and without VBA, along with extensive experience in data transfer, formatting, and analytics (data vis More

$77 CAD in 3 days
(0 Reviews)
0.0