Good morning, everyone, the present problem: It consists of 2 parts:
First part of the problem. First we have two sheets: Sheet1 and SP2 In Sheet1 we have key elements column B which contains codes from row 5 downwards and then we have row 3 to the right starting from column L which contains certain inputs.
The objective is to look in the SP2 sheet for the code in column B with a certain row, for example if my code is B10 = 02.04.03.01 in the SP2 sheet it would be from the A343 and now in the corresponding labor input in row 3 the amount corresponding to column F should be placed between this code and the input place the amount of the input from sheet SP2 on Sheet1, corresponding to that code. as seen in row 10 and 22 as an example.
Second Part of the Problem. In cell AC2 I have a drop-down list, which corresponds to an input from row 3 starting with column L, If I chose the operative input to give an example, it would mean that I would multiply the value of the code corresponding to column "O" by column F and place each of the numbers in the box from AG in the row corresponding to the determined code . according to the dates between ac and ad
First part of the problem. First we have two sheets: Sheet1 and SP2 In Sheet1 we have key elements column B which contains codes from row 5 downwards and then we have row 3 to the right starting from column L which contains certain inputs.
The objective is to look in the SP2 sheet for the code in column B with a certain row, for example if my code is B10 = 02.04.03.01 in the SP2 sheet it would be from the A343 and now in the corresponding labor input in row 3 the amount corresponding to column F should be placed between this code and the input place the amount of the input from sheet SP2 on Sheet1, corresponding to that code. as seen in row 10 and 22 as an example.
Second Part of the Problem. In cell AC2 I have a drop-down list, which corresponds to an input from row 3 starting with column L, If I chose the operative input to give an example, it would mean that I would multiply the value of the code corresponding to column "O" by column F and place each of the numbers in the box from AG in the row corresponding to the determined code . according to the dates between ac and ad
