Hello guys,
so, for the problem, please see attached.
I'm trying to figure out, if there is the possibility to fill values from the table, "fc table.png" into specific cells in the next sheet, "main excel.png" automatically. So I would come into a sheet with the table, fill in different numbers, usually from - (0) to 30, fill in different dates and all the values would paste themselves into the other sheet.
As an example, I circled yellow the cells that would have the information input. So the table shows GB28GB01 - you can see those values in the cell "Supplying..", circled yellow, then GB01 again circled yellow, and the date 17/10/2022, again circled yellow. And there's one row because the table says "1". If there would be 8, for example, there would be 8 rows copied under each other.
Is there a way to make this fully automatic? So I input different dates and different numbers each time (the GB..GB.. stays the same, always.) and Excel would fill all the cells and as many times as the table says? Perhaps this is not a topic for this category?
Please, if any of you have any idea or could point me in the right direction, I would appreciate it!
Bookmarks