Forum Discussion
macro move line from one sheet to another
Hi all, I have never made a macro befor and i need some help. I need a macro Which is triggered by putting a name in the drop-down menu in column "L". I have 3 names to be sorted into 3 d...
Didn't quite get it to work. attaching the parameters I must have in my workbook.
| Parameter | Value |
| first column to be moved | A |
| Last column to be moved | L |
| From sheet | I arbeid |
| To sheet | Tone |
| Column that determines relocation | L |
| Value that triggers move | Tone |
| Parameter | Verdi |
| first column to be moved | A |
| Last column to be moved | L |
| From sheet | I arbeid |
| To sheet | Jan Gunnar |
| Column that determines relocation | L |
| Value that triggers move | Jan Gunnar |
| Parameter | Verdi |
| first column to be moved | A |
| Last column to be moved | L |
| From sheet | I arbeid |
| To sheet | Vivi-Ann |
| Column that determines relocation | L |
| Value that triggers move | Vivi-Ann |
I've adapted the macro to the requirements.