Copy last entered cell value to all

Highlighted
Super Contributor

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%

 

 

Sorna Raja Prabhu
4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Copy last entered cell value to all

Hi Prabhu,

 

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

001.png

 

Regards,

Vignesh M

Highlighted
Master Anaplanner/Community Boss

Re: Copy last entered cell value to all

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

Highlighted
Super Contributor

Re: Copy last entered cell value to all

Thank you so much Lipchean, It works. 🙂 🙂
Sorna Raja Prabhu
Highlighted
Super Contributor

Re: Copy last entered cell value to all

THANKS VIGNESH, IT WORKS. 🙂

Sorna Raja Prabhu