Wayne Rogers
New Member
- Joined
- Aug 5, 2014
- Messages
- 17
I have managed to get through numerous macro/VBA issues in my new work book that i'm putting together, however i'm completely stumped on this one.
I have a gross profit report that shows all the sales data by sub catergories, but i need to be able to summarise the values in the main catergories in a different sheet.
I.e. the sub category numbers are in column A and their names are in column B and their relevant costs are in column F
1002 BB 31,239
1007 CC 109,903
2072 DD 78,563
8739 EE 29,765
etc etc there are roughly 18 - 22 rows of data depending on the stores sales
I'd like to be able to add the value (£) for groups 1002 and 2072 and put it in 1 cell and then add groups 1007 and 8739 into the cell below on a different tab called Summary
I hope I've explained it clearly ?
Many thanks
Wayne
I have a gross profit report that shows all the sales data by sub catergories, but i need to be able to summarise the values in the main catergories in a different sheet.
I.e. the sub category numbers are in column A and their names are in column B and their relevant costs are in column F
1002 BB 31,239
1007 CC 109,903
2072 DD 78,563
8739 EE 29,765
etc etc there are roughly 18 - 22 rows of data depending on the stores sales
I'd like to be able to add the value (£) for groups 1002 and 2072 and put it in 1 cell and then add groups 1007 and 8739 into the cell below on a different tab called Summary
I hope I've explained it clearly ?
Many thanks
Wayne