Excel Date Setting

S

Simont485

Joined
Feb 23, 2018
Messages
67
Reaction score
24
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!!!
 
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:
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Is this possible?? 3
Excel 2 into 1 6
Excel "Freezing" multiple rows in Excel (not the typical) 0
Duplicate a set of rows for each item (subdatasheet?) 0
Excel Dragging countif formula with changing criteria 3
Excel MS - Excel 5
formula help 2
Excel 2007 - freeze multiple panes? 2

Back
Top