I have made a coloured box from A1,K1 toA17,K17, where people enter some information.
When they are finished, they can press a button that as a macro that paste that same box to A19,K19 to A35,K35 empty.
What i am trying to do is from that button, the box would just paste itself to a open space on the same sheet like it would ad +2 every time.
So a new box would open every time that button would be press.
Hope someone gets the idea!!!