auto select end of line row and colomn ? copy to sheet1 from another file. C20 SHOULD NOT GREATER THAN A20 C20+E20=A20 AND SHOULD BE SAME A2 fullname = short name if there is no data , 0 should not come, empty formula should hide, but we can modify the data.?
Solved by M. S. in 11 mins