Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #16  
Old 04-03-2018, 12:34 PM
ArviLaanemets ArviLaanemets is offline How to create an Auto list with No Blank Cell -- HELP Windows 8 How to create an Auto list with No Blank Cell -- HELP 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



Quote:
Originally Posted by IBRA2018 View Post
2- About the year 2017. This is an example only and the sheet can be named anything, but I create new sheet for every year
And create a report sheet for new year too (and maybe some other too, as you find that you need some additional reports)! And then after a year again new sheets etc.

Really you need a sheet ProjectSteps to enter most of info (sheet Projects is needed for data entry only when you register a new project - and when you close an ended one). Instead of designing a new report every year (Btw, the sheet Projects serves really also as a report), you design reports where you select year/date and maybe some other conditions, and a report for those conditions is displayed (a single sheet for 1 kind of report). And when the number of registered project steps grows too much and as result the workbook will slow down (it depends on your computer, but unless you have really crappy one some 20000 rows must work OK), you archive the workbook with different name, clear old data (or too old data), and continue with same workbook. You need to redesign the workbook only, when you want to add some new functionality to it.

An additional bonus for such design is, that it allows to handle projects, which take several years of work.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Drop Down list to change cell color bksmith Excel 2 08-21-2017 02:37 AM
Have a cell filled black when blank in dropdown list Aussie_81 Excel 14 04-06-2017 04:50 AM
How to create an Auto list with No Blank Cell -- HELP Formulato say if cell is blank do this, if not blank do this. mbesspiata Excel 1 01-17-2015 05:02 AM
Auto add a list cell if the last list cell is filled tasuooooo Excel 1 07-31-2012 08:40 PM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:00 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