Producing a login sheet for excel and a linking stock with an ordrpage.
 

Hi,

A couple of things that i could do with some advice on

1. I making a system for a computer sales company and need to put in
a login page. This could be a simple drop down list with a password
and on correct entry the other sheets appear?

2. On the same spreadesheet there will be details of stock and also an
order form. I need the the stock to reduce as an order is made
(according to the amount of each item sold). Any ideas on how this
could be done? Would the order form need to list all stock and it
reduce each time?

Many Thanx