Completed

Excel/Word Code Required: Remove blank cells for picking slip

Hi all,

<Please see macro or [login to view URL] attached in case the formatting of this post is not clear.

Goal: To extract data from populated fields using Microsoft Excel (Product1 – attached) and then generate a mail merge picking slip in Avery 7169 (TBC) size Labels in Microsoft Word.

The picking slip will contain:

ID: <ID>

Name: <NAME>

ADDRESS 1: <ADDRESS 1>

ADDRESS 2: <ADDRESS 2>

SUBURB: <SUBURB>

STATE: <STATE>

POST CODE: <POST CODE>

Then see below an example of what should follow:

I need to avoid unnecessary fields or values to be shown like:

For this example I need Product A, Product D and Product E Removed

I would also like some basic training on how to modify the code if the list gets smaller or larger.

I am looking for a keen, energetic and genuine person who takes pride in their work, that has a good track record or examples of other work completed on Freelancer or elsewhere. Someone who is patient and understanding as VBA/Code is all new to me. I am located in Australia and am in the Australia Daylight Saving Time Zone.

I am thinking that $60 USD is around the right price, but if you feel different please let me know.

Ongoing support may also be needed which can be discussed separate of this project.

I am looking forward to working with the right person. Please feel free to ask any questions you may have.

Thank you.

Minya

Skills: Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps

See more: scan document excel word project, code required bid, entry excel word, return a list of non blank cells from a column of text values, excel array formula remove blanks, excel remove blanks from list formula, excel remove blank cells in column formula, excel data validation list remove blanks, excel ignore blank cells in named range, excel condense list with blanks formula, excel dynamic list without blanks, transfer data excel word, vba macro generate report excel word, excel word adobe, print label excel word, teaching math excel word, excel word copy, vba excel word preserving format, fill blank cells data vba excel, macro code generate report excel word

About the Employer:
( 5 reviews ) Macleod, Australia

Project ID: #18042132

Awarded to:

beltran0404

Hello Minya, This is Luis and I will be glad to assist you with this project. I can put your data from Excel into word or we could also do all in work if you like. I have experience in this type of projects then I More

$60 USD in 3 days
(99 Reviews)
5.3

38 freelancers are bidding on average $90 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$100 USD in 2 days
(651 Reviews)
8.3
schoudhary1553

Hello! Welcome to vibrant webtech and I was glad to see that you're looking for help for project Remove blank cells for picking slip. Please let me know when you need this project to be completed and your minimu More

$60 USD in 1 day
(298 Reviews)
7.7
bouslimi1979

Hi, do you have a Word Template ? or should we create the word template ? Else all the other points are clear, and the table will be adapted to the number of products. Thanks

$60 USD in 2 days
(269 Reviews)
7.5
paris2785

Hello, Minya! My name is Paris and just had the chance to read your project's brief. I used the Word attachment which is extremely descriptive and to the point. I have developed similar projects using VBA code, wher More

$90 USD in 3 days
(172 Reviews)
6.9
Tanmoy236

"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m More

$120 USD in 3 days
(177 Reviews)
6.6
TonmoyRoy111

Hello Miniya, I understand whats your requirement. I can write the code for you which will exactly do the same thing as you mentioned. Kindly contact me. Roy

$70 USD in 1 day
(279 Reviews)
6.6
$50 USD in 1 day
(68 Reviews)
5.8
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl More

$60 USD in 1 day
(77 Reviews)
5.8
supper5guy

Hello there, as an expert in excel and VBA, i can help you to accurately remove blank cells and re-order your data as you have specified. Please contact me and let us talk more about your project. Thanks

$55 USD in 3 days
(76 Reviews)
5.5
kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis More

$55 USD in 1 day
(74 Reviews)
5.8
usmanhassan123

phd in computer science having seven years of experience in Excel development.

$100 USD in 1 day
(45 Reviews)
5.8
sloker18

I am proficient with excel macro/VBA development, I can write the macro to generate mail merge result as specified, if you are interested feel free to message me, I am available to start your project immediately, looki More

$60 USD in 1 day
(50 Reviews)
5.1
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached files. I have already developed VBA Program (Macro) for Mail Merge with Excel/CSV, Access, SQL, MySQL More

$60 USD in 3 days
(69 Reviews)
5.3
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

$150 USD in 3 days
(58 Reviews)
5.4
prasannjeetp

Hi, I am an Excel Expert with very good knowledge of VBA. I can write code to generate mail merge labels in word doc. Please come on chat for more details. I will do it for 60 USD. No issues Thank you Awaiting More

$60 USD in 2 days
(37 Reviews)
4.3
webanis

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

$35 USD in 0 days
(18 Reviews)
4.1
lightingdavid

Hello. I have good skills in Excel/VBA. I have read your project description carefully and i can do it. Contact me please. Thank you.

$60 USD in 1 day
(6 Reviews)
2.9
akkijhamta

hello sir i will do this project for you professionally as you mentioned in detail kindly send me your project detail so we can discuss further thankyou

$30 USD in 3 days
(3 Reviews)
1.9
YogeshMoorthy11

Hi Minya, I go through the project and seems like to be an easy one because I know Vlookup which is commonly used in the Microsoft Excel that is familiar to me.I know how to work on it very well.I will promise you to More

$66 USD in 3 days
(0 Reviews)
0.0
coriandercode

Welcome to my profile. I'm rich experienced with the developments of Desktop & Mobile App and Website . Your satisfaction is a duty for me, so I'll do our best on your project. ? 8+ years of experience in dev More

$155 USD in 3 days
(0 Reviews)
0.0