Hello Excel Universe,
I have a spreadsheet of large amount of data that has dates with information listed under each date. Is there a code that will allow me to enter a date in a selected cell and it will jump to that column based on the date i entered instead of having to scroll over?
For example: If 4/30/17 is entered in A1, the cursor will jump over to AH1 . Hope this makes sense.
<tbody>
</tbody>
I have a spreadsheet of large amount of data that has dates with information listed under each date. Is there a code that will allow me to enter a date in a selected cell and it will jump to that column based on the date i entered instead of having to scroll over?
For example: If 4/30/17 is entered in A1, 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 |
<tbody>
</tbody>