A
alanled
Hi Im trying to setup a system for our 'goods in' the attached shee
would be on a pc at the 'goods in ' area hooked up to our network. I
the office we have a individual parts list for each job. I want to b
able to input a component on the parts list and when I enter a orde
number in the cell at that row it will copy the row to a row on th
attached sheet (goods in). When the tick box is ticked i.e th
component is 'in' I want a cell on the parts list (in the office)to sa
'goods in' or some kind of alert. Any help would be great someone ha
suggested using a VLOOKUP but I havent got a clue how to start. Man
thanks
would be on a pc at the 'goods in ' area hooked up to our network. I
the office we have a individual parts list for each job. I want to b
able to input a component on the parts list and when I enter a orde
number in the cell at that row it will copy the row to a row on th
attached sheet (goods in). When the tick box is ticked i.e th
component is 'in' I want a cell on the parts list (in the office)to sa
'goods in' or some kind of alert. Any help would be great someone ha
suggested using a VLOOKUP but I havent got a clue how to start. Man
thanks