move cells from column to multiple non adjacent columns

[abdelfattah]

hello
i search macro move from cell in column to another non adjacent columns i have col b when i write data then move to col d an when i write in col d move to col f and when write in col f return in col b

thanks

 

[GWteB]

You don't need a macro for that. Unlock the affected columns and protect your worksheet.
Be sure the "After pressing Enter move selection" is enabled and Direction is set to Right (Ribbon > File > Options > Advanced > Editing Options).