Excel to Word Macro - Quarter Page Results

Terminé Publié le il y a 5 ans Paiement à la livraison
Terminé Paiement à la livraison

*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

Traitement de Données Excel VB.NET Visual Basic Visual Basic pour les apps

Nº du projet : #18550305

À propos du projet

23 propositions Projet à distance Actif il y a 5 ans

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(440 Commentaires)
6.9

23 freelances font une offre moyenne de 133 $ pour ce travail

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. Plus

$180 USD en 3 jours
(309 Commentaires)
7.7
zebracaro

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(118 Commentaires)
6.6
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(174 Commentaires)
6.5
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..

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(44 Commentaires)
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 Plus

$222 USD en 3 jours
(118 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(44 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(32 Commentaires)
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 en 3 jours
(17 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
3.3
dilanharshan143

Hello, there, I am very happy to put my bid on your project. I am an expert of software development, so I am interested in and confident to do this project. And I am c. member of c. team whit $0 developers who have g Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

$277 USD en 0 jours
(0 Commentaires)
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 Plus

$111 USD en 0 jours
(0 Commentaires)
0.0
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Emmascottgfx

Good day, My name is Olorunsola Babatunde Am an HND holder in computer engineering Am very good with documents and content presentations I have an excellent computer skills Skills * Very fast typist * Excellent a Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

$111 USD en 6 jours
(0 Commentaires)
0.0