3 improvements on an Excel Macro ( read them before bidding )
Budget: €30 – €250 EUR
Hello,
I have a macro (attached) that almost does what I need, but a few improvements must be made before i can use it, exactly 3 improvements for now.
EXPLANATION OF HOW IT WORKS AND WHY:
The idea behind this excel macro is to transform a "list of items in a table" into something my clients can make orders with, there are 4 sheets:
1º "Listado ( no modificable )" sheet: It is the table with all the items available to sell. Always same columns.
2º "Run Macro" sheet: it is a sheet with only a button to trigger the macro.
3º "Realizar pedido" Sheet is a sheet that is created when the macro runs. Here is where my clients can type how many units they want. They indicate so typing how many units they want per model under the column header with name "Uds deseadas", which means "units wanted" in english.
4º "Resumen del pedido" sheet: it is the summary of the order. It is a sheet where my clients can review the units chooosen on the "Realizar pedido" sheet and check what they have included in the order.
IMPROVEMENTS NEEDED:
a) Change the "run macro" button to the sheet called "Listado ( no modificable )". There is no need for having that extra sheet. Unnecessary.
b) "Realizar Pedido" and "Resumen del pedido" must start empty, unless this excel had been saved by the client. Right now everychange made on the excel is saved, and can not be undo.
c) On the "Realizar pedido" sheet, if you type for example 1 unit wanted, but then change it to 0 again, then that line or unit must be erased from "Resumen del pedido" sheet as well.
Thanks
I have a macro (attached) that almost does what I need, but a few improvements must be made before i can use it, exactly 3 improvements for now.
EXPLANATION OF HOW IT WORKS AND WHY:
The idea behind this excel macro is to transform a "list of items in a table" into something my clients can make orders with, there are 4 sheets:
1º "Listado ( no modificable )" sheet: It is the table with all the items available to sell. Always same columns.
2º "Run Macro" sheet: it is a sheet with only a button to trigger the macro.
3º "Realizar pedido" Sheet is a sheet that is created when the macro runs. Here is where my clients can type how many units they want. They indicate so typing how many units they want per model under the column header with name "Uds deseadas", which means "units wanted" in english.
4º "Resumen del pedido" sheet: it is the summary of the order. It is a sheet where my clients can review the units chooosen on the "Realizar pedido" sheet and check what they have included in the order.
IMPROVEMENTS NEEDED:
a) Change the "run macro" button to the sheet called "Listado ( no modificable )". There is no need for having that extra sheet. Unnecessary.
b) "Realizar Pedido" and "Resumen del pedido" must start empty, unless this excel had been saved by the client. Right now everychange made on the excel is saved, and can not be undo.
c) On the "Realizar pedido" sheet, if you type for example 1 unit wanted, but then change it to 0 again, then that line or unit must be erased from "Resumen del pedido" sheet as well.
Thanks