View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tiya Tiya is offline
external usenet poster
 
Posts: 44
Default Protect cell pls help...

Thanks Shailesh Shah for reply

I can't keep seprate master sheet. I have to add or delete items of all the
product code so i have put all product codes together with item and to view
all of them together.

Thanks
Tiya
"" Shailesh Shahwrote:

You keep seprate master sheet of your all item codes & use data
validation in your stock list sheet.

See below Topics from Debra Dalgleish's site for the Data Validation &
one example for order form.

http://www.contextures.com/xlDataVal01.html

http://www.contextures.com/xlOrderForm01.html


Regards,
Shah Shailesh
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdex http://www.developersdex.com ***