ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Using a calander for date select in cell (https://www.excelbanter.com/excel-worksheet-functions/80186-using-calander-date-select-cell.html)

A

Using a calander for date select in cell
 
I have a list of customers I deal with on a weekly/biweekly/monthly basis,
so I want to enter a 'next visit' date, and there are a couple of things
I'm hoping to do.

1. I'd like to have a calander pop-up, so you can just click on the date.

2. I'd like to have the sheet continuously sort itself, so that the most
current date is always at the top of the page. So, as soon as I change the
date, it disapears and resorts itself to the appropriate position in the
list.

Is this possible?


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com