Forum Discussion
Solved
Formula pulling on-going data from one sheet to another automatically
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 (automat...
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.
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.
HansVogelaar Yes! It finally worked. Many Many Many thanks Hans! Cheers!
