Formula pulling on-going data from one sheet to another automatically

[frankjzee]

Sheet 1 - I have a column dates (A2 to A20) in which dates will fill the cells over time.

Sheet 2 - I have a row of blank cells (B2 to V2) that I want to fill with the dates from Sheet 1 (automatically) as they're inputted.

The formula would need to grab the dates entered down column A in Sheet 1 & input them across row 2 of Sheet 2.

Is this possible? Please help. 

Frank 

[#2 · Accepted solution]

@frankjzee 

Select B2 on Sheet 2.

Format this cell as a date.

Enter the formula

=IF(INDEX(Sheet1!$A:$A,COLUMN())="","",INDEX(Sheet1!$A:$A,COLUMN()))

Fill to the right as far as you want.

You may have to widen the columns to display the dates correctly.

[#3]

@Hans Vogelaar Yes! It finally worked. Many Many Many thanks Hans! Cheers!