I have created a spreadsheet for inventory use with a lot of help from existing posts which I appreciate. However I have hit a serious snag.
I have a running total in cell H4 based upon delivered stock being entered at cell F4. i.e. -

Column F, Row 4 - is a random number entered based on stock arrival (not including backorders).
Column H, Row 4 - contains a starting total of 150 - F4 is added to this total accordingly.

Aditionally, I have a running total in cell I4 based upon a full stock order (including backorders) at cell E4.i.e. -

Column E, Row 4 - is a random number entered based on the total stock order, including backorders.
Column I, Row 4 represents, therefore, total purchases - E4 is added to this total accordingly.

The code I have utilised is as follows:

Please Login or Register  to view this content.
Everything is working beautifully on Row 4. H4 and I4 are keeping the designed running total. However, I am at a loss as to how I transfer those parameters to the rest of the worksheet. It contains 257 individual items. The spreadsheet has been saved as *.xlsm format.

Any help woul be much - Than you in advance.