Dear All
Could you please advise a VBA code or Excel advanced functions to automatically shift entire rows from one area to another.
What I mean by area - is that I have 3 areas with 3 different color depending on certain cells values or status of the row.
So once a certain cell is updated and status changed, I need to shift down or up to particular area.
Also, once certain cells are updated I need to move entire row to a new sheet within the same workbook.
Thanks a lot!
Could you please advise a VBA code or Excel advanced functions to automatically shift entire rows from one area to another.
What I mean by area - is that I have 3 areas with 3 different color depending on certain cells values or status of the row.
So once a certain cell is updated and status changed, I need to shift down or up to particular area.
Also, once certain cells are updated I need to move entire row to a new sheet within the same workbook.
Thanks a lot!
