Excel VBA Project -- 2
Budget: $15 – $25 USD
Hey, I have a little excel file and I want to connect some sheet and update via capture data with VBA
What we need:
I know the Excel have the variables in Spanish but, you go to used like variables…
We have the Sheet “Reportes” “Captura Orden” “CapturaCierre” “CapturaPagos” “Datos” “Variables”
“Datos” is the database, with the variables to be filled
In my first step to fill this database we use “Captura Orden”
I create a VBA to fill, show messages and clear the cell when I finish, and work fine.
I need a variable in this VBA for validate all cell are filled, I forget to doit before the lines of sumit form, also I need to add a row in here and in “Datos” with the “User”, we need this, because we want to add the name of the person how’s do the work, selecting from a list using data validation and “Variables” Sheet
And validate the format of the cell, Fecha is Dates, Hora is Hours, millas is miles are only number,
Tell me if this is possible for you, I don’t have problem to paid for this.
Secod Step is “CapturaCierre”
In this sheet we have few rows to fill and my concerns is use Work Orders to find the right number and row in “Datos” and fill this info in the right cell in the database Parent table with parent caption field, I know in my first script the system look the first available row and write the info but for this second and third step we need to find and update
Estatus Row update the “Estatus” variable in “Datos”
Fecha de Cierre row update the “Fecha de cierre” variable in “Datos”,
Horas Trabajadas row update the “Horas Trabajadas” Variable in “Datos”
And for summit the form I need the same message and validation I write in the “NuevaWO” script with the messages and clear the fill, and validations, copy and paste from the first one.
Third Step is “CapturaPagos”
Is the same of the second one,
We need to find the WO in “Datos” for update this info
row “Fecha de Cobro” is “Fecha de cobro” Variable in “Datos”
“Cobrado” is “Cobrado”
“Notas” is “Notas”
And for summit the form I need the same message and validation I write in the “NuevaWO” script with the messages and clear the fill, and validations, copy and paste from the first one.
And for the “Reportes”
In a resume of the “Datos”
Row “Ordenes totales” need to show the numbers of total WO in the “Datos”, im trying to see how use this Excel for different month, but now my wife want one for each, but we go to continue to work in this in a week. Now we can use from the row 1 to the row 150 because she don’t have more than 120 orders at month
“Ordenes x Cerrar” show only the quantity of orders with the variable “Estatus” - “No Iniciado” “Por Documentos” ”Pendiente Pago”
“Ordenes x Cerradas” show only the quantity of orders with the variable “Estatus” - “cerrado”
“Total $ Ordenes” show the sum of the “Cobrado”in “Datos” of all WorkOrders quantity
“Total $ Pendiente” show the sum of the “Esperado” in “Datos” of all WorkOrders with the variable “Estatus” - “No Iniciado” “Por Documentos” ”Pendiente Pago”
“Total $ Cobrado” show the sum of the “Cobrado” in “Datos” with the variable “Estatus” - “Cerrado”
“Total de Horas” show the sum of the variable “Horas Trabajadas” in “Datos” no Estatus variable need it
“Promedio $ Horas” mean “Total $ Cobrado” divide with “Horas Trabajadas” with “Estatus” “Cerrado”
And the last and easy, is “Total de Millas”, is the sum of all “millas” x 2 times, because we fill the miles for one way, but for taxes need to use for the trip, that meas x2
I hope my text are clearly for you, and is you need something more, please write me, I be working in a DataCenter today with some servers updates and upgrades
What we need:
I know the Excel have the variables in Spanish but, you go to used like variables…
We have the Sheet “Reportes” “Captura Orden” “CapturaCierre” “CapturaPagos” “Datos” “Variables”
“Datos” is the database, with the variables to be filled
In my first step to fill this database we use “Captura Orden”
I create a VBA to fill, show messages and clear the cell when I finish, and work fine.
I need a variable in this VBA for validate all cell are filled, I forget to doit before the lines of sumit form, also I need to add a row in here and in “Datos” with the “User”, we need this, because we want to add the name of the person how’s do the work, selecting from a list using data validation and “Variables” Sheet
And validate the format of the cell, Fecha is Dates, Hora is Hours, millas is miles are only number,
Tell me if this is possible for you, I don’t have problem to paid for this.
Secod Step is “CapturaCierre”
In this sheet we have few rows to fill and my concerns is use Work Orders to find the right number and row in “Datos” and fill this info in the right cell in the database Parent table with parent caption field, I know in my first script the system look the first available row and write the info but for this second and third step we need to find and update
Estatus Row update the “Estatus” variable in “Datos”
Fecha de Cierre row update the “Fecha de cierre” variable in “Datos”,
Horas Trabajadas row update the “Horas Trabajadas” Variable in “Datos”
And for summit the form I need the same message and validation I write in the “NuevaWO” script with the messages and clear the fill, and validations, copy and paste from the first one.
Third Step is “CapturaPagos”
Is the same of the second one,
We need to find the WO in “Datos” for update this info
row “Fecha de Cobro” is “Fecha de cobro” Variable in “Datos”
“Cobrado” is “Cobrado”
“Notas” is “Notas”
And for summit the form I need the same message and validation I write in the “NuevaWO” script with the messages and clear the fill, and validations, copy and paste from the first one.
And for the “Reportes”
In a resume of the “Datos”
Row “Ordenes totales” need to show the numbers of total WO in the “Datos”, im trying to see how use this Excel for different month, but now my wife want one for each, but we go to continue to work in this in a week. Now we can use from the row 1 to the row 150 because she don’t have more than 120 orders at month
“Ordenes x Cerrar” show only the quantity of orders with the variable “Estatus” - “No Iniciado” “Por Documentos” ”Pendiente Pago”
“Ordenes x Cerradas” show only the quantity of orders with the variable “Estatus” - “cerrado”
“Total $ Ordenes” show the sum of the “Cobrado”in “Datos” of all WorkOrders quantity
“Total $ Pendiente” show the sum of the “Esperado” in “Datos” of all WorkOrders with the variable “Estatus” - “No Iniciado” “Por Documentos” ”Pendiente Pago”
“Total $ Cobrado” show the sum of the “Cobrado” in “Datos” with the variable “Estatus” - “Cerrado”
“Total de Horas” show the sum of the variable “Horas Trabajadas” in “Datos” no Estatus variable need it
“Promedio $ Horas” mean “Total $ Cobrado” divide with “Horas Trabajadas” with “Estatus” “Cerrado”
And the last and easy, is “Total de Millas”, is the sum of all “millas” x 2 times, because we fill the miles for one way, but for taxes need to use for the trip, that meas x2
I hope my text are clearly for you, and is you need something more, please write me, I be working in a DataCenter today with some servers updates and upgrades