Macro challenge to Subtotal Stock Report 09:24 26 Feb 2003

A stock report gives the quantity of each product in different store locations.
The name of each product 1 appears on the first row in its own column. Following rows contain the store name followed by the stock of product 1 in the store for 4 different package sizes. (All in separate columns). The number of stores (rows) listed can vary for each subsequent product.
A blank row separates product 1 detail from the next product name and details. There could be up to 50 different product details listed on one report..
I would like to sub total the stock for each individual product package size using a macro.

Can anyone help?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Indie publisher Canongate’s top 10 book covers of 2017

New iMac Pro release date, UK price & specs rumours

Tablettes Amazon Fire : quel modèle choisir ?