BlairClark
New Member
- Joined
- Mar 23, 2019
- Messages
- 4
Hi,
I'm trying to create a macro that looks up the word "Insert" in column E2, copies the contents from A2:G20 and pastes in the row directly below (A3:G21). I'm hoping to loop the macro because there's the possibility that more rows need the same argument.
<tbody>
</tbody>
Any help would be appreciated.
Blair
I'm trying to create a macro that looks up the word "Insert" in column E2, copies the contents from A2:G20 and pastes in the row directly below (A3:G21). I'm hoping to loop the macro because there's the possibility that more rows need the same argument.
A | B | C | D | E | F | G | |
1 | SKU | Description | Start | End | Comments | Hours | Cases |
2 | 1001 | LB 12x330 | 25/03/19 05:30 | 26/03/19 02:30 | Insert | 3000 | |
3 | 1003 | LB 24x330 | 26/03/19 03:30 | 26/03/19 22:00 | 2579 | ||
4 | 1010 | LR 12x330 | 26/03/19 23:00 | 27/03/19 19:30 | Insert | 5000 | |
5 | 1011 | LR 24x330 | 27/03/19 20:30 | 28/03/19 16:00 | Insert | 5000 | |
6 | 1009 | ST 12x330 | 28/03/19 17:00 | 28/03/19 23:00 | 2000 | ||
7 | 1008 | ST 24x330 | 29/03/19 00:00 | 29/03/19 20:00 | 4000 | ||
8 | 1007 | SP 12x330 | 29/03/19 21:00 | 30/03/19 04:00 | Insert | 3790 | |
9 | 1006 | SP 24x330 | 30/03/19 05:00 | 30/03/19 18:00 | 3330 |
<tbody>
</tbody>
Any help would be appreciated.
Blair