Hi, every one please help me out on this....
I have to make the table in which these are the columns and rows where Available data is the stock available and sale data is the one which i want to insert manually but remaining data will automatically be calculated,
for suppose I have available data dozens and units I have sold dozens and units now the remaining data will automatically be subtracted from available data....

User posted same question on this site and received an answer.

http://www.excelguru.ca/forums/showt...zens-and-units

Thanks for that Charles. It is super annoying to fix an issue for someone to find out they already had it fixed because they did not say they cross posted.