chrisgarcia78
New Member
- Joined
- Jun 15, 2024
- Messages
- 31
- Office Version
- 2021
- Platform
- Windows
I have the following data located on column D to J and rows 163 to 177 but I want to automatically move cell with value to the top row 163,164,165... for example if cell D163 = 0 and D164 >= 1 then move data from D164 to D163, or if only D170 and D160 => 1 then move those to D163 and D164.
any suggestions? thank you in advance.
D E F G H I J
=P3 =Q3 =R3 =S3 =T3 =U3 =V3
=P5 =Q5 =R5 =S5 =T5 =U5 =V5
=P12 =Q12 =R12 =S12 =T12 =U12 =V12
=P15 =Q15 =R15 =S15 =T15 =U15 =V15
=P18 =Q18 =R18 =S18 =T18 =U18 =V18
=P20 =Q20 =R20 =S20 =T20 =U20 =V20
=P25 =Q25 =R25 =S25 =T25 =U25 =V25
=P28 =Q28 =R28 =S28 =T28 =U28 =V28
=P33 =Q33 =R33 =S33 =T33 =U33 =V33
=P36 =Q36 =R36 =S36 =T36 =U36 =V36
=P38 =Q38 =R38 =S38 =T38 =U38 =V38
=P43 =Q43 =R43 =S43 =T43 =U43 =V43
=P46 =Q46 =R46 =S46 =T46 =U46 =V46
=P51 =Q51 =R51 =S51 =T51 =U51 =V51
=P54 =Q54 =R54 =S54 =T54 =U54 =V54
any suggestions? thank you in advance.
D E F G H I J
=P3 =Q3 =R3 =S3 =T3 =U3 =V3
=P5 =Q5 =R5 =S5 =T5 =U5 =V5
=P12 =Q12 =R12 =S12 =T12 =U12 =V12
=P15 =Q15 =R15 =S15 =T15 =U15 =V15
=P18 =Q18 =R18 =S18 =T18 =U18 =V18
=P20 =Q20 =R20 =S20 =T20 =U20 =V20
=P25 =Q25 =R25 =S25 =T25 =U25 =V25
=P28 =Q28 =R28 =S28 =T28 =U28 =V28
=P33 =Q33 =R33 =S33 =T33 =U33 =V33
=P36 =Q36 =R36 =S36 =T36 =U36 =V36
=P38 =Q38 =R38 =S38 =T38 =U38 =V38
=P43 =Q43 =R43 =S43 =T43 =U43 =V43
=P46 =Q46 =R46 =S46 =T46 =U46 =V46
=P51 =Q51 =R51 =S51 =T51 =U51 =V51
=P54 =Q54 =R54 =S54 =T54 =U54 =V54
Last edited: