Thread: Inventory: formula to show parts to order.
View Single Post
 
Old 04-22-2018, 10:54 AM
melvin1942 melvin1942 is offline Windows 10 Office 2007
Advanced Beginner
  
Join Date: Apr 2016
Posts: 42
melvin1942 is on a distinguished road
Default Formula for inventory
I am needing a formula to calculate the qty to order in column I. And I would like to take column E and column I and show the PART NUMBER and QTY TO ORDER on sheet 2. I would also like to show them in columns A and B on sheet 2 and put them in the first empty cells so they could be printed as an PART ORDER if it is possible.

Thank you for your help.

Melvin1942
Attached Files
File Type: xlsx Inventory.xlsx (10.8 KB, 12 views)
Reply With Quote