Auto filling a list with dates and times

[john dalton]

I have an appointment book which auto fills from another sheet but I need to create a client tracker so that the date and time are listed next to the client,

Please see the attached workbook

Any help would be appreciated,

JD

[:) Sixthsense :)]

In F2 Cell - Array Formula

Please Login or Register  to view this content.

In G2 Cell - Normal Formula

Please Login or Register  to view this content.

In H2 Cell - Array Formula

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Drag the formula's down...