Data Input

[Guest]

I have a spreadsheet set up containing products with a uniq reference code. I need to input sales quantities against these products each week. At present this is done manually. Has anyone any ideas how to auto mate this function. The sales quantities can be downloaded into an excel file

Regard

Blueman

 

[Frank Kabel]

Hi
you may have a look at pivot tables if I understood you
correctly

-----Original Message-----
I have a spreadsheet set up containing products with a

uniq reference code. I need to input sales quantities
against these products each week. At present this is done
manually. Has anyone any ideas how to auto mate this
function. The sales quantities can be downloaded into an
excel file.