Quote Originally Posted by ncmay View Post
Try the attached file and see if it does what you want.
It was written in Excel 2010 but saved as Excel 97-2003 so hopefully it functions properly for you.
Macros will have to be enabled.
Enter the vendor info
Once inventory is entered as received or used, press a cell in column E to activate the macro

Norman
Not much luck, can you resend it but as excel 2010?
Michaelaw