Do some Excel Work
$30-250 USD
Pagado a la entrega
I work for a small battery pack production company. We are ramping up production and need to have documentation for each lot. I've been searching for a solution that, ideally, would allow me to print several copies of a BUILD TRAVELER with a unique number on each copy that coincides with the build number, lot, and customer purchase order.
Is there a way in VBA to have a cell that incrementally changes with each print?
Product b-k640
Customer CoreLT
Lot # 008/300 <-----This number changes with each print.
Build Date 1/14/2015
Alternatively, I could have a macro that generates a workbook with several build travelers, either on the same worksheet or on several worksheets. I'm just not sure where to start.
Nº del proyecto: #6979527
Sobre el proyecto
Adjudicado a:
My priority is to finish this project cheap, fast and with quality output to earn good reputation. I have lot of experience with excel and VBA as I use it in my daily work. I can assure you that if you work with me on Más
Hello, You need simple macro. I can do it. Could you look at it? [login to view URL] If you have any questions I will be happy to answer. Best Regards Jan Krzyzak
15 freelancers están ofertando un promedio de $98 por este trabajo
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
Greetings Dear, I am an expert in VBA and MS Office Applications with +15yrs of experience. Basically, everything is possible programmatically in VBA and what you have requested of incrementing the numbers is very m Más
I have a good experience in VBA Macros, Automation, Formulas, Conditional Formatting, Pivot Tables, etc. Regarding your project, from my understanding you want to enter the details and then those details will get re Más
Hello, I am interested in this project and can write a macro which will print several copies of active spreadsheet and increment your given cell after each copy.
hello sir I can help u with document problem I have good command in ms excel as I am an engineer that's why previously worked with several reports and billing docs . if given a chance I assure u for quality and good w Más
Should be able to use VBA to detect printing and increment a variable when it happens. Either that or tie printing to a button that handles the variable and the print action. Should be an easy job.
Hello Sir ! I am working as computer operator in my country but i want to earn money from internet. I have joined free lancer since 2001 but i have not find or someone have not given me project. So, i am hopeful that y Más