Forum Discussion

frankjzee's avatar
frankjzee
Copper Contributor
Sep 01, 2021
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 (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 

 

Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Sep 01, 2021

    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.

     

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 01, 2021

    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.

     

Resources