exel planning moving dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2648178%22%20slang%3D%22en-US%22%3Eexel%20planning%20moving%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2648178%22%20slang%3D%22en-US%22%3E%3CP%3Eik%20want%20to%20make%20a%20planning%20but%20have%20a%20problem.%20i%20want%20to%20easely%20move%20these%20names%20when%20there%20is%20somting%20that%20has%20to%20move.%20I%20have%20added%20an%20example%20with%20fake%20names%20as%20an%20attachtment.%20so%20when%20the%20project%20of%20van%20russel%20then%20i%20have%20a%20gap%20and%20it%20would%20be%20usefulle%20if%20i%20can%20drag%20the%20other%20to%20there%20new%20destination.%20my%20problem%20is%20that%20there%20are%20other%20cels%20in%20between%20that%20have%20to%20be%20left%20alone%20so%20i%20want%20to%20move%20my%20oppointmens%20and%20the%20have%20to%20be%20automaticly%20re%20arranges%20in%20the%20green%20cells.%20this%20means%20that%20i%20can%20drag%20en%20drop%20the%20first%20name%20for%20exaple%20the%20pol%20in%20week%202%20on%20wensday%20and%20the%20rest%20wil%20automaticly%20go%20underneat%20and%20only%20come%20in%20the%20green%20cells%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Etanks%20for%20helping%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2648178%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2648234%22%20slang%3D%22en-US%22%3ERe%3A%20exel%20planning%20moving%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2648234%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1128396%22%20target%3D%22_blank%22%3E%40jancavanwesemael%3C%2FA%3E%26nbsp%3BNot%20sure%20if%20I%20understand%2C%20but%20perhaps%20you%20can%20reorganize%20the%20planning%20schedule%20a%20bit%20so%20that%20you%20no%20longer%20have%20the%20gaps%20between%20the%20weeks.%20Then%2C%20you%20can%20select%20a%20range%20of%20cells%20and%20drag%20them%20to%20another%20position%20in%20column%20C%20where%20there%20is%20space.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.