browncountry
New Member
- Joined
- Feb 2, 2019
- Messages
- 13
A | B | C | D | E | F | G | H | I | J | |
1 | Kit P/N | Kit S/N | Kit Part | Kit Parts S/N | Kit P/N | Kit S/N | ||||
2 | Kit 1 | 123 | Part 1 | 001 | Kit 1 | 123 | ||||
3 | Part 2 | 002 | Kit 2 | 456 | ||||||
4 | Part 3 | 003 | Kit 3 | 789 | ||||||
5 | Kit 2 | 456 | Part 1 | 004 | ||||||
6 | Part 2 | 005 | ||||||||
7 | Kit 3 | 789 | Part 1 | 006 | ||||||
8 | Part 2 | 007 | ||||||||
9 | Part 3 | 008 | ||||||||
10 | Part 4 | 009 |
<tbody>
</tbody>
If anyone has some time to help, I would like to be able to copy & paste values from single cells into merged ones via VBA. I can do this manually, but it gets tedious even with formulas.
In the table above, imagine Kit 1 is merged from A2:A4 and Kit 1 S/N is merged from B2:B4, Kit 2 is merged from A5:A6 and Kit 2 S/N is merged from B5:B6, and Kit 3 is merged from A7:A10 and Kit 3 S/N is merged from B7:B10.
The amount of kits vary on any particular sheet. I have formulas that create serial numbers for Columns I and J. I would like to select all serial numbers in Column J into the corresponding merged cells of Column B. Please help if you can. This would be a big time saver for me. Thanks in advance.