gr8trthanu
Board Regular
- Joined
- Nov 14, 2008
- Messages
- 103
I am creating a schedule where I can schedule my clients.
Instead of scrolling down 10,000+ lines to the date I need to make the appointment on I would like to:
#1 enter the date in cell D2
#2 hit a command button called cmdsearch date
#3 excel would look down column "D" for the value I placed in "D2" and select the cell holding the exact date.
All the dates are in column D as well.
I have tried to search for similar code and have failed.
thank you in advance.
Instead of scrolling down 10,000+ lines to the date I need to make the appointment on I would like to:
#1 enter the date in cell D2
#2 hit a command button called cmdsearch date
#3 excel would look down column "D" for the value I placed in "D2" and select the cell holding the exact date.
All the dates are in column D as well.
I have tried to search for similar code and have failed.
thank you in advance.