Conditional copy of cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2752037%22%20slang%3D%22de-DE%22%3EConditional%20copy%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752037%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DennisBasusta_0-1631695948858.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310531i6C237ADE0D01B337%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DennisBasusta_0-1631695948858.png%22%20alt%3D%22DennisBasusta_0-1631695948858.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20Sheet%20I%20have%20a%20gantt%20timing%20plan.%20It%20contains%20about%2020%20different%20Projects.%3C%2FP%3E%3CP%3EEach%20having%20about%2030%20Milestones.%20Every%20milestone%20is%20a%20seperate%20row%2C%20which%20makes%20the%20sheet%20very%20uncomfortable%20to%20read.%3C%2FP%3E%3CP%3EWhat%20i%20want%20to%20do%20now%20is%20write%20all%20Milestones%20per%20project%20in%20one%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefor%20i%20need%20to%20have%20a%20formular%20that%20does%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20each%20coloumn%20from%20%22M%22%20on%3A%3C%2FP%3E%3CP%3E-%20search%20for%20the%20rows%20that%20are%20the%20same%20project.%26nbsp%3B%3C%2FP%3E%3CP%3E-%20compare%20the%20year%20and%20date%20of%20the%20coloumn%20with%20the%20%22Jahr%22%20(year)%20and%20%22KW%22%20(calenderweek)%20in%20G%20and%20J%3C%2FP%3E%3CP%3E-%20if%20the%20%22duration%20KW%22%20(duration%20CW)%20is%20%22milestone%22%2C%3C%2FP%3E%3CP%3ECopy%20the%20cell%20to%20this%20one%20row%2C%20that%20shall%20contain%20all%20Milestones.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20this%20example%3A%20row%2011%20should%20then%20contain%20all%20Milestones%20that%20are%20found%20in%20this%20Sheet%20that%20belong%20to%20the%20Project%20AU591.%20And%20they%20should%20be%20in%20the%20correct%20coloumn%20with%20the%20correct%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2752037%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

DennisBasusta_0-1631695948858.png

 

In my Sheet I have a gantt timing plan. It contains about 20 different Projects.

Each having about 30 Milestones. Every milestone is a seperate row, which makes the sheet very uncomfortable to read.

What i want to do now is write all Milestones per project in one row.

 

Therefor i need to have a formular that does the following:

 

in each coloumn from "M" on:

- search for the rows that are the same project. 

- compare the year and date of the coloumn with the "Jahr" (year) and "KW" (calenderweek) in G and J

- if the "Dauer KW" (duration CW) is "Meilenstein", 

Copy the cell to this one row, that shall contain all Milestones.

 

In this example: row 11 should then contain all Milestones that are found in this Sheet that belong to the Project AU591. And they should be in the correct coloumn with the correct date.

 

 

0 Replies