Excel stock and sales data management

Question

I would like to get data from input to the master table.

Input data columns:

id; purchase no; date; ammount; total value

Input data example:

100; 1-PJ1-11; 01.06.2016.; 10; 70,00
100; 2-PJ1-11; 03.06.2016.; 5; 35,00 

I need this data to be in the master sheet in columns next to the same product id for each work day. Or possibly for selected date...

The master sheet looks like this:

id; purchase price; sales price; margin; and here I need to have the data for each work day based on input data. So if I had new purchase it will be shown here for a certain date.

I know there are many possible options but would like you to point me in the right direction.

Currently, I do it manually with the sheet where I insert the input data per each workday and vlookup it back to the master sheet also for every workday which is really not the best possible option.

Input data currently looks like this :

I would like it to look like this 

he master sheet looks like this 

I would like to pull the data from the new input table to the master sheet for each work date. Can someone please help me with this?

Answer 1

you must attach the event handler each time after generating a new row.

var i = 0

$('#txt_transferencia_codigo' +  i).blur(function () {
  if ($('#txt_transferencia_codigo' + i).val() !== '')
    console.log($('#txt_transferencia_codigo' + i).val())
})

$('#btn_transferencia_nuevo').click(function () {
  i = i + 1
  console.log(i)
  $('#tabla_transferencia').prepend('<tr id=\'row' + i + '\'><td><input type=\'text\' id=\'txt_transferencia_codigo' + i + '\'></td></tr>')
  var inputElement = $('#txt_transferencia_codigo' + i)
  attachBlurEvent(inputElement, i)
})

function attachBlurEvent(inputElement, i){
  $(inputElement).blur(function () {
  if (inputElement.val() !== '')
    console.log(inputElement.val())
})
}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<table class="table table-striped table-bordered" id="tabla_transferencia">
    <thead>
         <tr>
             <th style="width: 80px">Codigo</th>
             <th style="width: 500px">Descripción</th>
             <th>Existencias</th>
             <th>Cantidad</th>
             <th>Costo/Unit</th>
             <th style="width: 40px">Total</th>
             <th></th>
         </tr>
     </thead>
     <tbody>
         <tr id='row0'>
             <td>
                 <input type="text" id="txt_transferencia_codigo0" placeholder="Ingese el código"/>
             </td>
             <td>
                 <label id="lbl_transferencia_descripcion"/>
             </td>
             <td>
                 <label id="lbl_transferencia_existencias"/>
             </td>
             <td>
                 <label id="lbl_transferencia_cantidad"/>
             </td>
             <td>
                 <label id="lbl_transferencia_costoUni"/>
             </td>
             <td>
                 <label id="lbl_transferencia_total">
             </td>
        </tr>
    </tbody>
</table>
<a id="btn_transferencia_nuevo" class="btn btn-default pull-left">Agregar</a>
<a id='delete_row' class="pull-right btn btn-default">Delete Row</a>