inventory stock+dispatch+monthly consumed

**hyderabadi** · 06-24-2011, 05:25 AM

hi

What i need is worsheet1 holds the inventory stock worksheet2 holds removal of goods. worksheet3 holds the monthly inward receipts and outward removal total consumed material with amount of a company. in a simple way i want you guys to understand my question please,
what i want to do in this inventory of excel is when i type in sheet 2 a code number or material name this should deduct from sheet 1 and to be added in sheet 3 as consumable product

any help will be appreciated

thanks.

**nawas** · 06-26-2011, 06:25 AM

I think Vlookup function would be the right one in your case, but to understand in a better way please upload a sample work book which includes your desired output.

Thanks

**hyderabadi** · 07-15-2011, 06:15 AM

hi i had upload a sample inventory like the same i hold total godown inventory this is just a part of the inventory what i want here please note

1st (bearing) sheet which holds the total quantity of bearing.
2nd (issuance) sheet which holds issuance of the bearings.
3rd (receipts) sheet which holds incoming stock of bearings.
4th (monthly consumption) sheet which holds the monthly turnover inwards and outwards.

what i want here is whatever the issuance from sheet2 should deduct from sheet1 and update the sheet once entered issuance in sheet 2.

sheet3. the receipts whatever received bearings entered in sheet3 should automatically update sheet1.

sheet4 should show overall monthly consumpted bearings inward and outward wise

any help would be appreciated.

thanks in advance.

**hyderabadi** · 07-26-2011, 04:13 AM

Any help would be appreciated

**hyderabadi** · 07-27-2011, 06:16 AM

need support please

**Bala K** · 05-26-2012, 08:35 AM

i want simple stock inward outward tool or excel sheet which contain automated formulas. any share with template really appreciate

**arlu1201** · 05-26-2012, 11:11 AM

Bala K,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.