I need to add today's date drop down in about 100 cells. Each cell needs to be separate from all the others (no linking the same date).
I have added the Microsoft Date and Time Picker via Developer Options once and linked it to a cell, but can't cut and paste it to other cells... So, that means I have to manually add each calendar and manually edit the cell linkage? That would take a very long time.
Is there a way to add multiple calendars and have Excel 'auto-adjust' the calendar to each cell?
Or maybe I need to ask it this way:
How can I quickly add a date selection drop down to over 100 cells at one time?