Do some Excel Work

Completado Publicado Jan 14, 2015 Pagado a la entrega
Completado 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.

Entrada de datos Procesamiento de datos Excel

Nº del proyecto: #6979527

Sobre el proyecto

15 propuestas Proyecto remoto Activo Jan 15, 2015

Adjudicado a:

dinomarinic

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

$30 USD en 2 días
(2 comentarios)
0.6
macroPOL

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

$39 USD en 1 día
(94 comentarios)
6.1

15 freelancers están ofertando un promedio de $98 por este trabajo

elqueabandona

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

$138 USD en 3 días
(332 comentarios)
7.5
zExcel

Hi, I'll be happy to help you with this project. I take pride in accuracy, timely completion and support within reasonable time after completion. Please feel free to message me if you need to discuss any questions Más

$120 USD en 1 día
(257 comentarios)
7.7
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Más

$150 USD en 5 días
(176 comentarios)
6.5
BadihBarakat

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

$77 USD en 3 días
(3 comentarios)
3.1
clearatul0

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

$88 USD en 3 días
(3 comentarios)
2.8
petrovp

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.

$30 USD en 2 días
(6 comentarios)
2.6
faisalkazmipro

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

$40 USD en 2 días
(0 comentarios)
0.0
okafran

I am a young man with hard working attitude. I work to ensure efficient work done. I have skills in Microsoft office especially Excel, which I mostly used at work and at church for preparation of their financial re Más

$155 USD en 3 días
(0 comentarios)
0.0
Khamlo

I use some VBA-coding in my job. I work at the laboratory whereas a lot of reports must be done quickly therefore I'm busy by programming VBA so the rest of the staff would work more productive while making reports in Más

$83 USD en 1 día
(0 comentarios)
0.0
lloydnjuguna

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)
0.0
olivelavi

A proposal has not yet been provided

$155 USD en 20 días
(0 comentarios)
0.0
shadowedvaca

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.

$55 USD en 2 días
(0 comentarios)
0.0
khalilsial09

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

$154 USD en 4 días
(0 comentarios)
0.0