|
|
#10
03-28-2018, 06:33 AM
|
|||
|
|||
I designed some additional sheets to demonstrate, how I would start with such task. Maybe you get some ideas.
In general - all data entry is done in tables. When you want to display it otherwise, you create a report. P.e. your sheet 2017 would be something like ReportProjectsYearly, where you select a year number, and all projects active in selected year are displayed. Having data entry in tables makes writing formulas much easier. 
|
|
|
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 |
 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 |
Windows 8 
Office 2016
Threaded Mode