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.
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 |