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](https://i.stack.imgur.com/xH3Nq.png)
I would like it to look like this ![input data new](https://i.stack.imgur.com/K4Q6V.png)
he master sheet looks like this ![master sheet currently - some hidden columns between PROIZVOĐAČ and ULAZ](https://i.stack.imgur.com/EGrax.png)
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?