Hello I want to create a button which copy and paste a certain range in B to E when i Press it. But when i repress the button the data should be in the first available column to the right of E. Which code should i use?
| Map6 | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | Data 1 | 1 | Data 1 | |||||||||||
| 2 | Data 2 | 2 | Data 2 | |||||||||||
| 3 | Data 3 | 3 | Data 3 | |||||||||||
| 4 | Data 4 | 52 | Data 4 | |||||||||||
| 5 | Data 5 | 5 | Data 5 | |||||||||||
| 6 | Data 6 | 4 | Data 6 | |||||||||||
| 7 | Data 7 | 3 | Data 7 | |||||||||||
| 8 | Data 8 | 45 | Data 8 | |||||||||||
Blad1 | ||||||||||||||
