Date Setting

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

  1. Simont485

    Simont485

    Joined:
    Feb 23, 2018
    Likes Received:
    12
    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
    1. Advertisements

  2. Simont485

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    1,384
    Location:
    Manchester
    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
    #2
    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.
Loading...