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