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?