Copy last entered cell value to all

prabhu

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%

 

 

VIGNESH.M

Hi Prabhu,

 

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

 

Regards,

Vignesh M

LipChean_Soh

Hi,

 

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

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

 

Thanks,

LipChean

prabhu

Thank you so much Lipchean, It works. 🙂 🙂

prabhu

THANKS VIGNESH, IT WORKS. 🙂