Dear all,
Every week, I copy a set of data into a new row/column, so that the diagram/graph shows an update of this weeks works. Needless to say, this is boring and time consuming work.
Now I figured out how to do this via a macro, but I do not know how to let it fill a new row right from the last one automatically. Now it just fills the same column of week 43 every time I click.
Can somebody help me out by explaining me what to do?

thank you!