Excel stock and sales data management

0 votes

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 :input data currently

I would like it to look like this input data new

he master sheet looks like this master sheet currently - some hidden columns between PROIZVOĐAČ and ULAZ

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?

Sep 22 in Others by Kithuzzz
• 20,660 points
43 views

1 answer to this question.

0 votes

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>
answered Sep 23 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Uipath(RPA) : read data from the PDF file and write to Excel file

If you want to use UiPath and ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
47 views
0 votes
0 answers
0 votes
1 answer

How to use data validation and 'no filter' in excel

eventually succeeded in resolving this. Effectively, Filter() ...READ MORE

answered Nov 4 in Others by narikkadan
• 37,660 points
35 views
0 votes
1 answer

I have filtered my Excel data and now I want to number the rows. How do I do that?

Solution Filter your data. Select the cells you want ...READ MORE

answered Nov 14 in Others by narikkadan
• 37,660 points
26 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
449 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,201 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
68 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
201 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
81 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP