Snackan1986
New Member
- Joined
- Mar 27, 2016
- Messages
- 10
Hi,
Setup:
I have data in colum "B:D". In column "B" there is an item number, in column "C" there is a category of the item (always 2 digits long) and in colum "D" I have an amount for each category. Note that all values in column "C" and column "D" is in the same cell (ctrl+alt+enter). Note that the category in column "C" always is on the same line as the amount in column "D")
Problem:
I need to summarise this in another table(or pivot table) as the screen shot below in column "G:J". If possible I want it solved through VBA so that I won´t need a lot of helper columns to solve it.
<tbody>
</tbody>
Thanks
<tbody>
</tbody>
Setup:
I have data in colum "B:D". In column "B" there is an item number, in column "C" there is a category of the item (always 2 digits long) and in colum "D" I have an amount for each category. Note that all values in column "C" and column "D" is in the same cell (ctrl+alt+enter). Note that the category in column "C" always is on the same line as the amount in column "D")
Problem:
I need to summarise this in another table(or pivot table) as the screen shot below in column "G:J". If possible I want it solved through VBA so that I won´t need a lot of helper columns to solve it.
B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|
2 | Detailed | Summary | |||||||
3 | Item | Short | Amount | Item | AA | BB | CC | ||
4 | Item1 | AA AA AA BB CC | 1000 -400 1000 -2000 -5000 | Item1 | 1600 | -2000 | -5000 | ||
5 | |||||||||
6 | Item2 | AA BB BB BB CC | Item2 | ||||||
7 | Item3 | etcetera | etcetera | Item3 | |||||
8 | Item4 | etcetera | etcetera | Item4 |
<tbody>
</tbody>
Thanks
<tbody>
</tbody>