Ceej76 explained :
'GS[_2_ Wrote:
;1602491']Ceej76 used his keyboard to write :-
A B C D E F G
H I
124504501800 170 TN439 14-May 160 06/04/12 TN440 124504501800 80
124504501100 36 TN440 14-May 160 06/04/12 TN440 124504501100 168
126636631800 86 TN439 14-May 90 06/04/12 TN440 124504501800 120
I am trying to work up a formula that would allow me to add quantity
received (I) to quantity on hand (B) by part numbers (H).
For example: If the item number is 124504501800 and I received 80
pieces in I would like a formula to add this to my existing inventory
under that part number.
Does this make sense?
The cell columes are A-I above....and 1-3 Rows
Thanks
Ceej-
In the cell to recieve the new quantity, type =B1+I1 (adjust for the
actual row number and copy down.
--
Garry
Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
Garry - I would like it to search for the item number and adjust it
automatically when I add the new inventory of the same item number.
Perhaps, then, you should look at the SUMIF() function or maybe the
SUMPRODUCT() function in the Excel Function Reference section of online
help.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion