<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:
ADDRESS 1: <ADDRESS 1>
ADDRESS 2: <ADDRESS 2>
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.
38 freelancers are bidding on average $90 for this job
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
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
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