I have a worksheet where every line is one of four "types". Once each line is worked and completed I move those lines to an "Archive" sheet based on their "Type".
Currently I have four separate automations that move a single "type" to it's respective worksheet.
The way I see current automation possibilities only allows me to look for one type, then the "otherwise" is single in depth. I.e. if Type1 move to Type1 Archive, otherwise move somewhere else… So, to accomplish my objective I have to have four separate automations.
Is there a work around I am not thinking of? Or is multiple automations the only way to accomplish this?