populate 'expense' column with total from 'net' column

[Dave Wheeler]

am still working with 'bar beverages' spreadsheet listing all spirits and ales bought from wholesale outlets......giving full purchase costs from invoice/receipts to show what brands have been purchased - how often - and how much it has cost monthly


EXPENSE COLUMN HEADINGS
###########################################################

SUPPLIER......GROSS......VAT......NET.........whisky......vodka......rum......lager...etc...etc

...xy & son.....184.68.....30.78.....53.90.....................153.90

..whiteys.........96.37.....16.06.....80.31..............................................80.31

just a simple basic spreadsheet that is filled by using a 'VAT calculator' which I've added to the top of each working sheet
the gross is entered in 'calc' BOX and press of COMMAND BUTTON sends GROSS and VAT
with help of LOOP macro - and totals are sent to respective columns.......NET is completed thro' MACRO in WORKBOOK VBA

I currently enter the NET figure in the appropriate column by scrolling each row on entry

I have added extra BOX on CALCULATOR to add COLUMN HEADING/REFS A , B , C etc to try and enter the NET amount with help of macro to send to whatever EXPENSE column

this would be very helpful when you are entering pages and pages at a sitting

I've tried various ideas but landed up with every cell on page with '0.00' in it
have tried RANGES and column refs......but no luck

can anyone give easy suggestion to tackle this
I would as usual be very grateful.........Blank boxes would also be super

thank you all