Find Jobs
Hire Freelancers

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

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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
ID del proyecto: 18042132

Información sobre el proyecto

35 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 can complete it for you and give you further assistance after completion. After completion I will also explain how to modify the code and I will let notes on it! Please contact me by chat and then we could discuss further details about your project! Kind regards, Luis Romero
$60 USD en 3 días
5,0 (172 comentarios)
6,0
6,0
35 freelancers están ofertando un promedio de $91 USD por este trabajo
Avatar del usuario
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 minimum budget. I've delivered more than 400 projects in the last 3 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I have more than 5 years of experience in Data Processing, Excel, VB.NET, Visual Basic, Visual Basic for Apps I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Please find my portfolio link below for your review: https://www.freelancer.in/u/schoudhary1553 Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon to discuss more details related to project.
$60 USD en 1 día
4,9 (544 comentarios)
8,4
8,4
Avatar del usuario
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, where attachments in Word, pdf or Excel format were sent along with an Outlook mail. Your task is straight-forward and I want to work with you. I'm going to spend less than 2-3 days to complete your project including required revisions for a total payment of $90 (a single milestone to be released once you're satisfied with the final file). I'm a very experienced and skilled MS Excel and VBA developer as you can check for yourself. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$90 USD en 3 días
5,0 (501 comentarios)
8,4
8,4
Avatar del usuario
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 en 2 días
5,0 (348 comentarios)
7,9
7,9
Avatar del usuario
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, looking forward to chat further and work on your project
$60 USD en 1 día
5,0 (159 comentarios)
7,5
7,5
Avatar del usuario
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 en 1 día
4,9 (501 comentarios)
7,4
7,4
Avatar del usuario
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 possible time and with the highest quality! From the Excel, Word and vba, of course, familiar. Give me a chance to show what I can do!
$60 USD en 1 día
4,9 (201 comentarios)
6,9
6,9
Avatar del usuario
"""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 more than 250+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$120 USD en 3 días
4,9 (269 comentarios)
7,1
7,1
Avatar del usuario
Hi, I am much interested in this project and I always wait for similar project or opportunity where I can explore my self and learn new things and techniques. I am good at excel and developed many process & project using VBA module or Macros. So,I would like to submit my proposal for this project and Please give an opportunity to work with you on this project so that I could develop a new process for you. please come on freelancer chat to discuss more on this project and I have gone through all the attachment.I will come with you the successful label as per requirement in case you award it to me. looking forward to work with you. Thanks Gopal
$60 USD en 3 días
5,0 (34 comentarios)
6,7
6,7
Avatar del usuario
phd in computer science having seven years of experience in Excel development.
$100 USD en 1 día
4,8 (93 comentarios)
6,5
6,5
Avatar del usuario
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 markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 USD en 3 días
4,7 (87 comentarios)
6,2
6,2
Avatar del usuario
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, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers.
$55 USD en 1 día
4,8 (89 comentarios)
6,2
6,2
Avatar del usuario
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 en 1 día
4,8 (100 comentarios)
5,9
5,9
Avatar del usuario
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 en 3 días
5,0 (85 comentarios)
5,8
5,8
Avatar del usuario
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 your response.
$60 USD en 2 días
4,4 (48 comentarios)
4,8
4,8
Avatar del usuario
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 en 3 días
3,9 (3 comentarios)
2,1
2,1
Avatar del usuario
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 developing desktop applications for the PC • C/C++ Programming • C#/VB.NET & JAVA Programming ? 6+ years of experience in developing Mobile Apps • Native Platform(All version of Android/iOS) • Hybrid / React Native • Backend API & 3rd Party API Manipulation. (Google, Instagram, Paypal and etc) ? 5+ years of experience in developing Games • Unity3D, Cocos2d ? 5+ years of experience in developing Websites • PHP / JavaScript(Angular/Node) • Wordpress, Joomla, Prestashop ( Plugins, Theme) • CSS Frameworks ( Bootstrap , Foundation ) • Database(Mysql/SQLite/Oracle/MongoDB) ? Why I am? * Honest and Polite * Daily / Weekly result, Responsible communication anytime. * 6 months Free bug fixing and maintenance after development. Thanks
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello I am an engineer looking for freelance jobs. I have a lot of experience as a freelancer and I have good computer skills. I am committed and respectful of deadlines and engagements.
$155 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am new in freelancer.com but have lot of experience in freelancing work. Please give me your project to prove myself. I am ready to do this. I view your the docs. Please send me details your work and get 100% satisfaction.
$60 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Good Day! I am interested to apply for the position of Data Entry. I am a degree holder with Major in Business Management, I have 3 years experience in Back Support/Admin Assistant. Proficient in Microsoft word and excel applications etc. My most recent job here in online job is I was in Home Health Company, my role is to review documents from the Clinicians/Nurses that they obtained from their Patients, transferring files into their own database, converting PDF into JPEG if necessary and putting some information of the patient into google spreadsheet for monitoring. I just also finished a 3 months project basis as data entry, they gave me an account to their system and then I will going to get information from call leads or logged calls of a service provider company and copy it to their google spread sheet. I am looking for a job so I can save money for my family and I think online job as Data entry suits for me because I am also taking care of my baby. If ever I met your qualifications you can contact me anytime you want. God bless and have a nice day!
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hey wsup good afternoon sir. well I can work with you.
$111 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Macleod, Australia
5,0
5
Forma de pago verificada
Miembro desde dic 16, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.