View Single Post
      10-27-2017, 08:42 AM   #4
Hawkeye
Brigadier General
Hawkeye's Avatar
No_Country
2070
Rep
4,365
Posts

Drives: '07 Z4 Coupe, '21 X3, '16 GMC
Join Date: Aug 2007
Location: Iowa

iTrader: (0)

Garage List
On the list of employees you can just hover over the bottom right corner of the table and drag it down to as many employees as you want.

The Employee data validation on the Calendar view tab is a named rage (lstEmployees) so it references the entire table column by default which you can see in the Formulas > Name Manager. There is nothing additional you should need to do aside from expanding the table and filling it in.

Edit: If you want to be able to check the formulas you can click in them to see what the main functions are, colored names are named ranges (mentioned above) and the other bits are TableName[TableColumnName] which are treated as an array of values from the referenced table and column.
__________________
2007 Z4 3.0si Coupe • 6 MT • Black Saphire Metallic • PP • SP
2016 GMC Sierra SLT Z71 Premium Plus 4x4
2017 Harley StreetGlide • Denim Black • V&H Tune
2021 BMW x30i • Phytonic Blue Metallic • Fully loaded

Last edited by Hawkeye; 10-27-2017 at 08:54 AM..
Appreciate 1