chrisgarcia78
New Member
- Joined
- Jun 15, 2024
- Messages
- 24
- Office Version
- 2021
- Platform
- Windows
Hi, I have the following rows in columns A,B,C
A10:A20
B10:B20
C10:C20
Each cell has a formula that gets a value of 0 or more, I would like to move all cells with values to the top rows starting on A10,B10, and C10.
for example: A10 and A11 has a value of "0" and all others with a value of "1" then move cells A12:A20 to A10:A18 and keep all original formulas including A10:A11 moved to A19:A20
Please help me with a solution.
A10:A20
B10:B20
C10:C20
Each cell has a formula that gets a value of 0 or more, I would like to move all cells with values to the top rows starting on A10,B10, and C10.
for example: A10 and A11 has a value of "0" and all others with a value of "1" then move cells A12:A20 to A10:A18 and keep all original formulas including A10:A11 moved to A19:A20
Please help me with a solution.