Завершено

Excel to Word Macro - Quarter Page Results

*Only bid if you can complete the project by 1/19/19 6:00 PM Eastern Standard Time*

I'm looking for a developer to build a basic macro to extract Excel data and place it into a Word document. If you think another output format would be better, I'm okay with discussing it. Perhaps having an output in Excel vs Word would be better, however I need to have it printed in quarter sheets.

Here's the VBA logic...

1. Users will have data populated in the "Data File" Excel file that's located in the Coop Card Macro folder with various data. The file may not be named as such, so upon execution of the macro, it should prompt the user to select the file to use. The information will be in the following order;

Column A - First Name (Field can be ignored and does not need extraction)

Column B - Last Name (Field can be ignored and does not need extraction)

Column C - Date (This date field will need to be pulled into the output file and will be the same for all cards)

Column D - Exhibitor # (This number will be printed twice on the output file and will also be used to control the macro. When the user executes the macro, they should be prompted with a message "Type in the Exhibitor Number or range". If they user were to enter in a single number, the output file should populate only that data. If the user enters a series or range, it should identify those. Users could type in 1, 5, 18, 19, 55 or they could type in 1-70 for example and it should populate and save accordingly)

Column E - Cage # (If this column has data, it should populate in the two areas on the output file)

Column F - Class (If this column has data, it should populate in the applicable area on the output file)

Column G - Breed (If this column has data, it should populate in the applicable area on the output file)

Column H - Variety (If this column has data, it should populate in the applicable area on the output file)

Column I - Age/Sex (This column may have other data that does not match on the output file and should be skipped/ignored if so. If the data in the column matches one of the four options (Hen/Cock/Pullet/Cockerel) then it should populate accordingly)

Column J - Division (Field can be ignored and does not need extraction)

The other areas of the Coop Card Output File can be ignored since this will contain hand written information.

When the output files are saved, you can have it add a number at the end as shown in the example. For example, if the user selects to print Exhibitor Numbers 1-10 it would produce 3 files. For the full file of this test, it would produce 16 output files for printing. Use the word COOP when responding with a bid so I know you reviewed the specs.

If you have any questions or change ideas that would make it function/look better, please let me know and I'll be happy to hear your thoughts.

Thanks,

Anthony

Квалификация: Обработка данных, Excel, VB.NET, Visual Basic, Visual Basic для приложений

Показать больше link data from excel to word, importing data from excel to word template, populate word document from excel vba, generate word document from excel data, how to transfer data from excel to word using vba, linking excel to word 2010, how to merge excel data into a word document, auto populate word document from excel, vba macro generate report excel word, vba word macro refrence excel range, excel word vba macro example, macro code generate report excel word, excel vba com send parameter word macro, vba open close excel workbook word macro, vba excel word macro, word macro create excel sheet, macro across excel word, excel word macro examples, excel macro read page, create excel word macro

О работодателе:
( 24 отзыв(-а, -ов) ) Sarasota, United States

ID проекта: #18550305

Поручен:

MimiFL

Hello, lets start first with word COOP as you suggested. Ok, next this can definitely be automated and yes the word is totally ok format. What i need is just a single (quarter) filled with any row of excel data, just s Больше

$130 USD за 1 день
(440 отзывов(-а))
6.9

23 фрилансеров(-а) в среднем готовы выполнить эту работу за $133

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Больше

$180 USD за 3 дней(-я)
(309 отзывов(-а))
7.7
SBITServices

COOP Hello Anthiony, I will submit it by 1/19/19 6:00 PM EST. I have done similar Excel to Word macro work.I have checked the attached files, can you explain clearly about "Column D - Exhibitor". I Больше

$50 USD за 1 день
(407 отзывов(-а))
7.4
avinav606lx

Hello there, I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Th Больше

$188 USD за 1 день
(174 отзывов(-а))
6.5
zebracaro

I can do it for you quickly and exactly. Please contact me for saving your time and your money .

$100 USD за 1 день
(118 отзывов(-а))
6.6
diorisaguilar

COOP It can be done through a console application (.exe file) where you just need to double click on it and it will prompt you the Excel file location and then the Exhibitor Number or range, and then it will create Больше

$140 USD за 1 день
(52 отзывов(-а))
6.2
axiomswb

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..

$100 USD за 1 день
(44 отзывов(-а))
5.8
bob1982

COOP i am very good in excel and word vba .infact this is the area i am more experienced i have read the description and has few doubts 1. for each row we need two cards to print? 2. you said " Exhibitor Number Больше

$222 USD за 3 дней(-я)
(118 отзывов(-а))
5.7
daniyal3214

I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform Financial Modeling, Financial Analysis, Financial Forecasting, Cash Больше

$100 USD за 1 день
(44 отзывов(-а))
5.3
aubrey03

COOP I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$100 USD за 2 дней(-я)
(67 отзывов(-а))
5.3
rumarahman

I have 10 years experience with Data Processing in Excel. I work with: Excel Data Processing Data Collecting (Using Macro) MS Office VBA Excel VBA Macro Automation User Forms Data Analyzing Pivo Больше

$180 USD за 1 день
(32 отзывов(-а))
5.0
lightingdavid

Hello? How are you? I have good skills in this field. so i can help you if you want Hope to work with you. Thank you.

$155 USD за 3 дней(-я)
(17 отзывов(-а))
4.9
Sercho56

**COOP** I have extensive experience in building logic modules in VBA. Having looked at your project, I think that it would be best to incorporate all the features into the one Macro-Enabled workbook. I will recreate Больше

$138 USD за 1 день
(9 отзывов(-а))
4.3
bhupendrayadav

I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple o Больше

$80 USD за 1 день
(16 отзывов(-а))
4.0
Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T Больше

$45 USD за 1 день
(14 отзывов(-а))
3.3
rageshpetra

Hello, I am Ragesh, I can do this project more efficient and prominent with speedy delivery within given time. I can assure you that this project I can finish it 100% accuracy. I hope to hearing from you. Thanks & R Больше

$277 USD за 1 день
(0 отзывов(-а))
0.0
Rksingh112

Hello, I am New Here, similar Excel to Word macro work. I will submit it by 1/19/19 6:00 PM EST.I have checked the attached files and i can do this work. I am Rohit Kr. Singh 2.5 Year Experience in our field, I a Больше

$40 USD за 1 день
(0 отзывов(-а))
0.0
$155 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
kaimenyijohn5

Hello, am glad i have found your project and wish to inform you that I have been a freelancer for more than 6 years. Therefore, I have the skills and expertise required to complete this project with detail-attention to Больше

$111 USD за 0 дней(-я)
(0 отзывов(-а))
0.0
mw03006706089

Dear client greetings of the day. I hope you are doing well. I review your request of data entry . I assure you I can sort you problem regarding excel in you are interested. I can also share a sample file of same type Больше

$111 USD за 6 дней(-я)
(0 отзывов(-а))
0.0
rusizinme

Dear Sir, At first take my great respect. I am a Data Entry worker .I would like to request you highly to give this project. I have been working as a Data Entry operator more than 3 years. I have completed many local Больше

$277 USD за 0 дней(-я)
(0 отзывов(-а))
0.0