Copy last entered cell value to all

Hi,

I am facing a problem, can someone solve it, please.

I have a module which has Employee, Time Range(FY01 to FY15) as Dimensions

                                            Line Item - IP(List format), Growth % (Number Format)

 

IP Line item is user input, by selecting a list item from a dropdown.

Growth % - Value(Name(IP)) - Will change to number format.

 

Let's assume that the user enters the value in the IP Line item for an employee from FY01 to FY04. as a result Growth % is also calculated from FY01 to FY04

 

My objective is when a user enters (LAST ENTER) the value in the IP Line item for an employee in FY05. 

That particular value should be copied to till the end(FY15).

 

Likewise when a user enters the value in the IP Line item for an employee in FY06. 

That value should be copied to till the end(FY15).

 

For Example

Emp-1  IP    Growth %

FY01     2       2%

FY02     4       4%

FY03     5       5%

FY04     3       3%

FY05     5       5%      -----> Last Entered

FY06     5       5%

FY07     5       5%

FY08     5       5%

 

 

Best Answers

  • Hi Prabhu,

     

    Use the "Previous" function to get this, see the screenshot below.

    001.png

     

    Regards,

    Vignesh M

  • Hi,

     

    I would add some conditions to @VIGNESH.M 's solution.

    Assume your FY is represented as Month in my suggestion below.

    Screen Shot 2019-12-19 at 07.21.52.pngScreen Shot 2019-12-19 at 07.22.06.pngScreen Shot 2019-12-19 at 07.22.16.png

     

    Thanks,

    LipChean

Answers