Write a Macro to print in Excel. Here is exactly what I need:
Right now I type "1" in a cell and then that customers information comes up on an invoice sheet I created. I then hit print. And then I move on to customer "2", hit print, and so on. I would like this automated so that it just prints until the end of the customers list and then stops.
Also, there are some customer accounts that have a zero balance and do not need to be printed. If a cell = 0, then that invoice is not printed and the Macro moves to the next customer number. But again, when the last customer number comes up, the macro stops printing.
I have 2 workbooks that need the same exact thing, described above. And then 2 more that need just basic printing Macro, 1,2,3,4,5, and so on until the end is reached.
I attached 2 example files.
Please ask any questions!
Hi,
I am good at Excel and vba. Looking forward to work on this project. I have gone through the description. I would like to know few things, before working on the project.
$30 USD en 0 día
5,0 (206 comentarios)
6,6
6,6
14 freelancers están ofertando un promedio de $43 USD por este trabajo
Hi there! Have prior excel experience and am an excel expert! Please feel free to ping me with any additional information or with questions if any! Thanks! -Steve
Hi! I have done this work before, and am an excel expert! I have taken a look at the attached spreadsheets, please let me know in case of any questions. Thanks!
Hi!
My name is Tomasz Kustra, and I am from Poland.
I am interested in this project.
I am experienced freelancer, you can see ma resume on Freelancer.com here:
http://www.freelancer.com/u/tomkusvw.html
And my another, unused now, account:
http://www.freelancer.com/u/tomkus.html
As you can see I have successfully completed few similar projects.
I am sure, that you will be glad of my work if you choose me.
With Best Regards
Tomasz Kustra
Hi, I am a software developer with experience building macro for Excel, Word and PowerPoint. I can help you in this matter but will need more details about your request, for example, where do you type "1" to retrieve the customer's invoice? . An explained workflow will be helpful. I will be open to any suggestion you could have after delivering the solution.
Hi I have a similar macro like this. If you award the project to me now I can start working on it right away and finish it in just few hours. Please feel free to contact me. thanks
Hello: I have build many sophisticated excel macro's for large companies and will have no problem building your macro quickly and to spec. I am fast, accurate and extremely reliable and would be happy to accept this project; as a new freelancer, I would welcome the opportunity to start building a solid reputation and an impressive rating by exceeding your expectations with timely, quality, consistent work.
My experience with excel VBA includes development of comprehensive payroll systems, as well as modular systems designed for more specific tasks. For this task, I will make a macro to iterate through the list of customers based on the condition that their balance is not zero, then print out the invoice.