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 ***