blackie42
04-12-2013, 07:54 AM
Hi,
In column A is the product , column B the cost.
I have sorted the sheet so it has the products in order - there are a number of products and the number of instances varies. So product A could have 3 entries, product B 10, Product C 6 etc.
I have managed to insert 3 lines in between each product group and would like to subtotal the cost in coulmn B using a macro. (simply beacause there are around 2500 entries in total)
Any ideas on how to do this please. Tried using autosum but can't copy this in code cos it uses cell references.
thanks
Jon
In column A is the product , column B the cost.
I have sorted the sheet so it has the products in order - there are a number of products and the number of instances varies. So product A could have 3 entries, product B 10, Product C 6 etc.
I have managed to insert 3 lines in between each product group and would like to subtotal the cost in coulmn B using a macro. (simply beacause there are around 2500 entries in total)
Any ideas on how to do this please. Tried using autosum but can't copy this in code cos it uses cell references.
thanks
Jon