manojxls
New Member
- Joined
- Dec 21, 2017
- Messages
- 32
- Office Version
- 365
- 2007
- 2003 or older
- Platform
- Windows
Hi Team, i need help on below sample excel vba
i have data in A column with two word in same cell i need to split in to two cell also amount need to divide half these should done until a column find blank cell.
ithe result should show as shown as right.
i have data in A column with two word in same cell i need to split in to two cell also amount need to divide half these should done until a column find blank cell.
ithe result should show as shown as right.
costcentre1 & costcentre2 | 400 | costcentre1 | =400/2 | |
costcent4 & costcentr25 | 500 | costcentre2 | =400/2 | |
costcent4 | =500/2 | |||
costcentr25 | =500/2 |