Hello community from Germany,
i need your help, regarding the following problem.
I am searching for a solution to refer column A in "Tabelle2" to the 9 red marked cells in "Tabelle3" with a few clicks (see the pictures below). I was trying to construct a macro but it turns out, that only column A from row 2-10 is copied into the empty cells the whole time. I need to fill in the first 9 products, print the worksheet "tabelle3" and start with row 11 upt to 19 just by starting the macro.
Maybe there is an easier solution solving my problem (maybe without a macro). Has anyone an idea?