Row should move in other Table if column "status" has the value "completed"

**LorisNic** · 08-17-2021, 11:15 AM

Hey all!

I'm sorry if I missed a same question in the forum but because I have no Idea about VBA-programming, I think I didn't made a good job in searching about this topic in this forum.

My problem: As you see in the file I made an Eisenhower-Matrix. If a project is completed it should disappear from the "Visualisation" so that we just have the visualtion of the due projects.
My Idea was to move the completed projects out of the table in the file "Overview" to a table in the file "Completed Projects" because then it would also disappear from the "Visualitation". But because I can't do this with normal formulas (as I've seen in different but similar questions on this forum) i'm completly overcharged.
Can you help me with a VDA formula for this kind of problem or do you have any suggestions about an other solution with the same outcome?

I'm very thankful about any help! Thanks!

**JeteMc** · 08-19-2021, 12:23 PM

Try the following:
1. For "Completed Projects" column A: =IFERROR(INDEX(Tabelle2[Projektname],AGGREGATE(15,6,(ROW(Tabelle2[Projektname])-ROW(Tabelle2[#Headers]))/(Tabelle2[Status]<>"completed"),ROWS(A$5:A5))),"")
2. Columns B:P =IFERROR(INDEX(Tabelle2[Spalte10],MATCH($A5,Tabelle2[[Projektname]:[Projektname]],0)),"")
Note that A5:P11 are custom formatted to hide zeros using [=0]""
3. For "Visualitation":

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Row should move in other Table if column "status" has the value "completed"

LinkBack

Thread Tools

Rate This Thread

Display

Row should move in other Table if column "status" has the value "completed"

Re: Row should move in other Table if column "status" has the value "completed"

Thread Information

Users Browsing this Thread

Similar Threads

Highlight column "due date" when passed but not if column "status" says "complete"

Lock row when I choose "Validated" in the column named "Status"

[SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"

[SOLVED] Move row from one worksheet to another on meeting "completed" criteria on status column

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"

If "Completed" then move entire row to "Completed" worksheet

Bookmarks

Bookmarks

Posting Permissions