Jump to cell using a date picker

[robocop]

Hello to all the excel gurus out there! I have a dilemma and hoping someone can help me out.

I have a spreadsheet of data that has dates with information listed under each date. Is there a code that will allow me to enter a date (using a date picker) in a selected cell and it will jump to that column based on the date i selected instead of having to scroll over?

For example: Using A1 as the designated date picker location, i would like to select a date (4/30/17) , the cursor will jump over to AH1 . Hope this makes sense.

	A	B	C	D	AH
1	4/30/17	1/13/17	1/14/17	1/15/17	4/30/17
2		$200	$400	$500	$600
3		$400	$500	$600	$700
4		$10	$20	$30	$50
5		$15	$25	$40	$55

 

[Joe4]

Okay! thanks for you help Joe, that will have to do.

If you have any problems getting the code to do what you want, or getting it to run automatically, post back.
If you put the code in the wrong place, it will not run automatically.