
Originally Posted by
ncmay
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
Bookmarks