Set value of second cell based on first cell in a range.

[ashokkumarkolla]

Hi all,

My data is in range A1:L10

If cell (A2) value is 1 then range A3:A10 values has to be 1.

Likewise for columns B:L

Thanks in advance.

Ashok

 

[NARAYANK991]

Hi ,

Just as you say that your input data range is A1:L10 , can you manually use another range to indicate what the output will look like ?

Manually enter the expected output in the range A12:L21 , and then upload the workbook.

Narayan

 

[ashokkumarkolla]

@Narayan

attached the output file for your reference.
Thanks
Ashok

 

[NARAYANK991]

Hi ,

Run the macro named FillDown in the attached file.

I assume that there is no data in those cells which are not having 1 in them , since the macro will overwrite all cells in the specified range.

Narayan

 

[ashokkumarkolla]

@Narayan

It worked great. Trying to understand the macro.

Meanwhile, i need to to fill values in reverse order for another condition.

If cell (A2) value is 1 then range A1:A2 values has to be 1.

Likewise for columns B:L,

Attached the output file for your reference.

Thanks for your help.
Ashok.

 

[NARAYANK991]

Hi ,

See the uploaded file , which has both macros FillDown and FillUp.

Narayan

 

[ashokkumarkolla]

@NARAYANK991
Thanks a lot.
Ashok

 

[ashokkumarkolla]

@NARAYANK991

While using the macro "FillDown", Remaining cells are filled with value"0" (for ex. A1, B1:B3, C1:C6,...)

But using the macro "Fillup", remaining cells are NOT filled with value "0".

Can you modify the macro "FillDown" so that remaining cells are not filled with "0".

Thanks
Ashok

 

[NARAYANK991]

Hi ,

See the uploaded file.

Narayan

 

[ashokkumarkolla]

@NARAYANK991

Thnak you very much,
Ashok.