Inventory: formula to show parts to order.

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Inventory: formula to show parts to order.

FAQ

Thread Tools

Display Modes

04-22-2018, 10:54 AM

melvin1942 melvin1942 is offline

Windows 10 Inventory: formula to show parts to order.

Office 2007

Advanced Beginner

Join Date: Apr 2016

Posts: 42

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

Inventory.xlsx (10.8 KB, 12 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula/VBA to identify order of entry dates	lesmielles	Excel Programming	3	02-08-2017 06:14 AM
Timeline creation - show events out of order	triallawyer	PowerPoint	0	03-17-2015 08:48 PM
Changing order of animations in slide show mode	mrbutler88	PowerPoint	1	02-14-2015 11:57 PM
Show & hide paragraphs, parts of tables, etc	Preloader	Word	2	10-19-2013 02:37 PM
add the functionality to show & hide paragraphs, parts of tables, etc	pgwolfe	Word	3	09-24-2013 07:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:31 PM.