Loading...

Inventory solution Microsoft Excel

791,349 views

Loading...

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Mar 9, 2012

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
http://www.familycomputerclub.com
A user has 4 sheets in his workbook called:
1. Items List
2. Received List
3. Issued List
4. Stock on site
From the items list he would like to enter the serial number into the received list and issued list sheets and automatically get the item description and unit. This can be achieved easily using the Vlookup function and a named range from the items list..
The stock on site also displays the relevat item description and unit. The total stock from the recieved list minus the quantity from the issued list is automatically displayed using the sumif function.
Finally we use the conditional formatting feature of Microsoft Excel to highlight negative quantities in case we have issued more quantity than received.
http://www.youtube.com/watch?v=JjM-8w...
For more details go here:
http://www.familycomputerclub.com/Inv...
You can download the template here:
http://www.familycomputerclub.com/Inv...
The link is below the video.
Get the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V
If you are from India you can get this book here: http://amzn.to/2jzJGqU

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...