I simply cannot solve this one, even if I customize similar codes from this web.

When I choose a value from my drop-down menu in cell G of the worksheet “Úkoly”, I need to search for the same value in row 4 of the sheet “Projekty” and copy the cells B:F of the original row from “Úkoly” to the last row below the found value of a sheet called “Projekty” (the sheet “Projekty” will have different projects in the row 4 next to each other and each project will have 5 columns). I hope this makes some sense.

Alternatively, I can make a tab for each project (around 50 projects) and the cell G will have to match the name of the tab and do the same process.

Thank you in advance, I really cannot wrap my head around this.

I tried many variants of codes from this web with no success, I hope someone helps me 🙂