decreasing from a stable Quantity Macro

[shahsavand]

i wanna decrease my stock with the last time i used my inventory.
for example ID no 1. my need is 200 and my stock is 5000 so my shortage is 5000-200=4800 then you can see we have this Id in another row in which my requirement is 54.here i wanna calculate it like this 4800-54=4746
(stock quantity is stable for each ID)
i need a macro for doing it.please somebody help me.

Product	ID	NEED	STOCK	Shortage
A	1	200	5000	4800
A	2	200	200	0
A	3	25	12	-13
A	4	5	36	31
A	5	6	254	248
B	6	4	23	19
B	7	21	36	15
B	1	54	5000	4946
B	2	6	200	194
c	65	69	100	31
c	3	54	12	-42
c	14	265	88	-177
c	26	32	99	67

<tbody>
</tbody>

 

[circledchicken]

You're welcome, I'm glad it helped (by the way I forgot to say the above formula should be confirmed with CTRL-SHIFT-ENTER rather than just ENTER as it is an array formula, but it seems like you already knew that).

Regarding learning Excel, I think a good way is just to look at posts here on the MrExcel forum. There are many very experienced users who post great solutions that you can learn from. You could also try posting solutions to other people's questions where possible, and that can be a good way of learning by doing.

There are a lot of other good resources too. Here is one list compiled by hiker95 that might be helpful:
http://www.mrexcel.com/forum/genera...917163-practical-excel-books.html#post4409672

I really like the ExcelIsFun Youtube videos as well:
http://www.youtube.com/user/ExcelIsFun