Date Setting

Excel Discussion in 'Microsoft Office' started by Simont485, Nov 8, 2018.

  1. Simont485


    Feb 23, 2018
    Likes Received:
    HI all

    As you may know I use excel for a staff rota.

    The dates are from D4 across to FF4 or whatever D4 plus 365 is......but it is a long way to scroll across!
    Columns AB&C are for names, information etc....these don't scroll as they are frozen(freeze panes)

    I was wondering this:

    Can I enter a date, in say Cell A1, and the spreadsheet scrolls across to that date and be next to column C?

    Hope that makes sense!!!
    Simont485, Nov 8, 2018
    1. Advertisements

  2. Simont485

    Becky Webmistress Administrator

    Mar 25, 2003
    Likes Received:
    I know you can use the Go To function to find certain cells (Ctrl + G) but I'm not sure how it can be done using a formula... I imagine it could be done through VBA though :nod:
    Becky, Nov 8, 2018
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
There are no similar threads yet.