Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #18  
Old 04-06-2020, 10:17 PM
ArviLaanemets ArviLaanemets is offline Due Date Summary based on multi-sheet spreadsheet Windows 8 Due Date Summary based on multi-sheet spreadsheet Office 2016
Expert
 
Join Date: May 2017
Posts: 949
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

From your example and from formulas on sheet DIREPs, it looks like DIREP is additional characteristic of document - parallel with DocClass. When this is the case, then you don't need additional sheet, but you need additional columns for DIREP indo in documents table.

At same time, from you having DIREP types listed in dropdown of DocClass, this assumes DIREP type are another document classes like release, training, etc. When this is the case, then a document can have only one of them selected - this means you need additional helper columns after column DCM in documents table. And again - no need for separate DIREP table.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Summriez all worksheet in summary work sheet MILADREZAEE Excel 7 05-21-2018 05:01 AM
How to calculate summary progress date time on summary tasks Logotip Project 0 05-16-2017 01:18 AM
Due Date Summary based on multi-sheet spreadsheet Creating a dynamic summary sheet FenelonPaul Excel 5 09-23-2015 07:11 AM
Due Date Summary based on multi-sheet spreadsheet Can a Data Source be one sheet in a multi-sheet Workbook nfotx Mail Merge 1 07-01-2015 12:55 AM
Due Date Summary based on multi-sheet spreadsheet Construct a summary sheet by summing up from one or more than one sheet. PRADEEPB270 Excel 1 11-04-2011 03:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:34 PM.


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