Restrict Entry to cell if it is out of Stock

Originally Posted by vipinpalkar

I have two sheets one is stock balance and other is sales..if my stock is less in stock balance sheet for a product entered in sales it should not allow me to enter using data validation or any formula or function. plz help me in this..I am attaching my sheet for reference.Attachment 411360

Dear Vipin,

Please find the attachment with your query solved.

Regards
M Srikanth

Mr. morasrikant noting is done in your attached sheet...i think you have send me the same attachment

Originally Posted by vipinpalkar

Mr. morasrikant noting is done in your attached sheet...i think you have send me the same attachment

Dear Vipin,

I have created a data validation for the QUANTITY column (column E) of SALES sheet which restrict from entering value more that stock available for the products.

Originally Posted by vipinpalkar

its not working morasrikant. plz if u can resend the file..will be thankfull

Dear Vipin,

Try this,

Select cells E6:E2000 in Sales worksheet and add data validation as "Whole number" and give values as
Minimum = 0 and
Maximum =INDEX(Stock.Balance!$F$6:$F$127,MATCH(D6,Stock.Balance!$C$6:$C$127,0))+$E6