[Willum]

Hi everybody,

I can't get the following macro proper.

I need a macro which copies S1:V64 (In S7 starts the data, but I think it is more easy tot start at S1) to another column. Column W till Z. When the macro is pressed for a second time, cells S1:V64 (or Cells W1:Z64) needs to be copied till AA till AD et cetera. I have attached an example of my page. The thing is that the row with totals, should move to the right. So this should be always at the end of it.

So does someone know which macro I need?

Something like (it's not correct, I don't know how I have to write it correct.

Selection S1:V64
ActiveCel.Copy


But then I need the row to be inserted before the Total row. Is someone able to help me?
Hope it's clear what my purpose is?

Thanks in advance!

[Willum]

Not necessary anymore! Found another solution.