exel planning moving dates

Copper Contributor

ik want to make a planning but have a problem. i want to easely move these names when there is somting that has to move. I have added an example with fake names as an attachtment. so when the project of van russel then i have a gap and it would be usefulle if i can drag the other to there new destination. my problem is that there are other cels in between that have to be left alone so i want to move my oppointmens and the have to be automaticly re arranges in the green cells. this means that i can drag en drop the first name for exaple the pol in week 2 on wensday and the rest wil automaticly go underneat and only come in the green cells

 

 

tanks for helping 

 

1 Reply

@jancavanwesemael Not sure if I understand, but perhaps you can reorganize the planning schedule a bit so that you no longer have the gaps between the weeks. Then, you can select a range of cells and drag them to another position in column C where there is space. See attached.