Ditutup

microsoft excel to microsoft publisher templates

I would like to have excel document coded to export the data from the data entry excel sheet to the corresponsing microsoft publisher template.

I would like to fill in an excel sheet then populate multiple Microsoft publisher templates. Each cell in excel would populate to a different template based on information in those cells. I would have a cell that would reference what template to use. I can do all this with mail merge but it would require me to open each publisher template and chose the data, which is time consuming. I could have up to 50 different templates.

attached screenshots of the excel data source and 2 of the publisher templates showing the placeholders.

Here is the basic outline of the project:

1. select column A (SKU) value which will be a drop down with Data Validation

2. column B, E, G will use a vlookup to fill in the default values

3. column C, D, F values will be typed in by the user

4. macro button (not displayed) to run a command for all items in column (E) = straight or scallop

a. use the template in column (G) and insert values from B, C, D, F onto the template where the placeholder is located

b. create one publisher document with each row template on a separate page

I'm able to do all the steps above with a mail merge in publisher, but the problem is that each template needs to be opened and mail merge one at a time. I will probably have close to 50 templates to reference so it would become to time consuming.

If the user could input everything into excel and run a macro that would replace the mail merge it would work perfect.

Kemahiran: Pemasukan Data, Excel, Microsoft, Microsoft Office, Visual Basic

Lihat lagi: brochure templates microsoft publisher, microsoft publisher newsletter templates, microsoft publisher 2003 templates, free publisher design templates, microsoft excel templates, ms word cover page templates free download, professional report template word, microsoft powerpoint templates, microsoft word 2010 templates free download, microsoft powerpoint themes free download, free word templates, microsoft publisher border templates, magazine layout templates microsoft publisher, free web templates microsoft publisher, microsoft office excel templates, microsoft publisher newsletter templates free, templates microsoft publisher broshure, bookmark templates microsoft publisher, magazines templates microsoft publisher, menu templates microsoft publisher

Tentang Majikan:
( 0 ulasan ) Sunbury, United States

ID Projek: #17929427

22 pekerja bebas membida secara purata $109 untuk pekerjaan ini

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project microsoft excel to microsoft publisher templates . I can assure you the quality job. I have good experience in Data Entry, Excel, Microsoft, Lagi

$200 USD dalam 3 hari
(290 Ulasan)
7.6
polarjin2017

Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.

$155 USD dalam 3 hari
(58 Ulasan)
6.2
dataexplorer

"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as Lagi

$100 USD dalam 3 hari
(14 Ulasan)
3.4
arslantahir87

Hellow Dere !! Thanks for taking the time to review my proposal! I’ve looked over your notes regarding your project i am a Professional freelancer with experience of more than 8 years plus relevant education & c Lagi

$30 USD dalam 3 hari
(19 Ulasan)
4.0
$166 USD dalam 5 hari
(0 Ulasan)
0.0
arpitaray55

Hi! I am offering my services on short notice. Relevant Skills and Experience Please consider me and give me a chance to impress you with my quality services. Thanks.

$40 USD dalam 3 hari
(1 Ulasan)
0.0
Iirin

hi, I’m interested in this job. I can do it properly. You Can Select me for Quality and Cheap Cost. We can discuss more over the message. I hope a positive answer from you.

$155 USD dalam 3 hari
(0 Ulasan)
0.0
maghifox

Hello Dear, I am an expert in Data Entry, Excel and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high qualit Lagi

$30 USD dalam 3 hari
(0 Ulasan)
0.0
saifurrehman4

i can do this project before provided deadline you can hire me for your work in low price and ill do it for you as soon as you hire me

$111 USD dalam 2 hari
(0 Ulasan)
0.0
$172 USD dalam 3 hari
(0 Ulasan)
0.0
$155 USD dalam 3 hari
(0 Ulasan)
0.0
$30 USD dalam 3 hari
(0 Ulasan)
0.0
Holden028

I have built and worked on mail merges and I know a way to have this resolved quickly. I frequently use word, excel & publisher day in and day out for me to print off my customer sign up packs for my small business. Lagi

$83 USD dalam 2 hari
(0 Ulasan)
0.0
$55 USD dalam 3 hari
(0 Ulasan)
0.0
ahmadzakuan1993

excel Relevant Skills and Experience excellent on excel to convert publisher in 3 minutes per spreadsheet

$166 USD dalam 3 hari
(0 Ulasan)
0.0
$30 USD dalam 3 hari
(0 Ulasan)
0.0
fredom12345

iam ready to do this

$155 USD dalam 3 hari
(0 Ulasan)
0.0
Muhammedrock321

There's nothing much to describe. I've worked in an Audit Firm for past one (1) year. I'm good in Microsoft Office. I can complete this task within the time given to me. I'm used to those workings which you've mentione Lagi

$155 USD dalam 3 hari
(0 Ulasan)
0.0
$111 USD dalam sehari
(0 Ulasan)
0.0
$155 USD dalam 3 hari
(0 Ulasan)
0.0