Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2018, 04:06 AM
ArviLaanemets ArviLaanemets is offline Inventory: formula to show parts to order. Windows 8 Inventory: formula to show parts to order. Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

An alternative without coding - you can do all this with formulas only.

I left all your sheets as they were and added new ones.

You can keep several inventories. I added QtyPurchased field so user can follow, were ordered parts received or not.

The print area definition for PartOrder sheet is based on Dynamic Name, so you can have any number of report rows prepared, but only rows not empty are printed.

In case you aren't familiar with defined Tables, to add a new row into table:
1. Select right bottom cell of Table, and press Tab;
2. Select any cell in Table, activate Design menu, and at left of header click Resize Table - set the number of rows you want in Table;


3. Enter something into next row at bottom of table (avoid columns with formulas, and columns with Data Validation for better too).

When you add a new row(s) into Table, Data Validations, Conditional Formatting, and formulas (latter in case the whole column has same formula) are copied into new row(s) automatically.

Some columns are hidden, as they are there to keep data needed for calculations and user don't need to see them. You can unhide them to to understand, how all works, of-course.
Attached Files
File Type: xlsx Inventory.xlsx (22.1 KB, 16 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inventory: formula to show parts to order. 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
Inventory: formula to show parts to order. 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 06:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft