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, 2022 in Others by Kithuzzz
• 38,000 points
794 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, 2022 by narikkadan
• 63,600 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, 2022 in Others by narikkadan
• 63,600 points
2,179 views
0 votes
0 answers

Data Driven Framework -- how to read and write in excel sheet using Selenium WebDriver with java

I'm using this code to read something, ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
• 38,000 points
662 views
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, 2022 in Others by narikkadan
• 63,600 points
627 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, 2022 in Others by narikkadan
• 63,600 points
1,127 views
0 votes
1 answer

Crawling through multiple excel files, match and copy data to master file

One application only. It would be quicker ...READ MORE

answered Jan 12, 2023 in Others by narikkadan
• 63,600 points
620 views
0 votes
1 answer

Create dropdown list in excel that displays different values from the same lookup table

Looks like the Worksheet_Change() sub needs two ...READ MORE

answered Apr 6, 2023 in Others by narikkadan
• 63,600 points
562 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,740 points
1,258 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
3,695 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, 2022 in Others by narikkadan
• 63,600 points
1,109 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