hi,

I've created a spreadsheet(workbook),columns A - E have other data in them, Column F i want to import data from a sage package. I've set column G to be the current stock level, column I i wish to use as any goods imported in, Column J is to issue goods out and column K is for any returns back.

When i input any data into columns I, J or K i wish them to either add or subtract from the stock level in column G, but i wish them to
refresh back to 0 (zero) after a set time(say 2 minutes for example) and the stock in column G to save as the new figure.

Does that make any more sense??

Is it a complex task??

Chris