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