Hello all,
In the past you helped me a lot, so I’m hoping you could help me again.
I’m looking for a macro which does 4 things:
- On “blad1” all used cells must be cleared, from cell A7 up to colum AS. In the attachment these would be all the cells with the name “bla” .
- When on “blad 2” there is a 1 in colum AI it has to copy the row up to colum AE. (in the example these say “copy”)
- After this it should be pasted on “blad 1” starting at A7.
- As final item it should copy the cells from “blad 3” A1 up to N1 (named “punt 4”) and paste it in “blad 1” behind the all rows it just copied from “blad 2”, colums AF up to AS (under de headers marked as “something”).
The list it would copy will have a different size every time this macro will be used.
I hope I’m being clear enough and someone can help me.
Bookmarks