Data from one form to another

[rjerand]

Hello, hope everyone is doing well!

In my spreadsheet, I have labeled Data areas A and B
I need the information in Data A to autopopulate to Data B
As you can see...
Data A starts by zone number and the product on a particular day.
Data B starts by product and then the zone number on that same day as seen in Data A.

I always enter the data into Data A and I need the information to autopopulate into Data B
I have attached a spreadsheet and have manually entered the data in Data B to show an example, but in the end, I would like for it to autopopulate.
The states have no effect on the function, but I had to include them.

I tried to do this myself using an Array, but came up empty

Any help would be great.

[Nvable]

rjerend,

Good day.

If understand you correctly, you want BOX A to AUTOPOPULATE in BOX B.

Please see attachment.

I am no expert, would like to contribute, so hopefully this helps.

Nvable

*EDIT: Disregard. This is above me.

[rjerand]

That is correct, when I fill out Data A (above data), I would like the bottom data (Data B) to autopopulate automatically as the Data A is entered.

[CARACALLA]

B17=IF($A17<>"",IF(COLUMNS($B$16:B16)<=$R$4,SUMPRODUCT(($C$3:$P$9=$A17)*($C$2:$P$2=B$16)*($A$3:$A$9)),""),"")

copy across and down