Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I need a code that when I highlight a row(s) it copies and inserts the row beneath and adds A & B to the end of data in C.
In the sample below if I highlight all three rows the data in C is different in C so I will need a total of 6 rows with A & B on the end in as the result
Result
Thanks.
In the sample below if I highlight all three rows the data in C is different in C so I will need a total of 6 rows with A & B on the end in as the result
Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
12 | MZC1820 2001 | data | data | data | data | ||||
13 | MZC1820 3001 | data | data | data | data | ||||
14 | MZC1820 4001 | data | data | data | data | ||||
Sheet1 |
Result
Excel Workbook | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
12 | MZC1820 2001A | data | data | data | data | data | data | data | ||||
13 | MZC1820 2001B | data | data | data | data | data | data | data | ||||
14 | MZC1820 3001A | data | data | data | data | data | data | data | ||||
15 | MZC1820 3001B | data | data | data | data | data | data | data | ||||
16 | MZC1820 4001A | data | data | data | data | data | data | data | ||||
17 | MZC1820 4001B | data | data | data | data | data | data | data | ||||
Sheet1 |
Thanks.