Lukket

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.

Evner: Dataindførsel, Excel, Microsoft, Microsoft Office, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Sunbury, United States

Projekt ID: #17929427

22 freelancere byder i gennemsnit $109 på dette job

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, Flere

$200 USD in 3 dage
(290 bedømmelser)
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 in 3 dage
(58 bedømmelser)
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 Flere

$100 USD in 3 dage
(14 bedømmelser)
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 Flere

$30 USD in 3 dage
(19 bedømmelser)
4.0
$166 USD in 5 dage
(0 bedømmelser)
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 in 3 dage
(1 bedømmelse)
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 in 3 dage
(0 bedømmelser)
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 Flere

$30 USD in 3 dage
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
0.0
$172 USD in 3 dage
(0 bedømmelser)
0.0
$155 USD in 3 dage
(0 bedømmelser)
0.0
$30 USD in 3 dage
(0 bedømmelser)
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. Flere

$83 USD in 2 dage
(0 bedømmelser)
0.0
$55 USD in 3 dage
(0 bedømmelser)
0.0
ahmadzakuan1993

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

$166 USD in 3 dage
(0 bedømmelser)
0.0
$30 USD in 3 dage
(0 bedømmelser)
0.0
fredom12345

iam ready to do this

$155 USD in 3 dage
(0 bedømmelser)
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 Flere

$155 USD in 3 dage
(0 bedømmelser)
0.0
$111 USD på 1 dag
(0 bedømmelser)
0.0
$155 USD in 3 dage
(0 bedømmelser)
0.0