将按颜色过滤的行复制到新表 [英] Copy Filtered Row by Color to new sheet

问题描述

我有一个如下所示的Excel电子表格:

I have an Excel spreadsheet that looks something like this:

|      | Job1 | Job2 | Job3 | Job4 | Job5 |
| Job1 |      |      |      |      |      |
| Job2 |      |      |      |      |      |
| Job3 |      |      |      |      |      |
| Job4 |      |      |      |      |      |
| Job5 |      |      |      |      |      |

每行和每列之间的单元格是不同的颜色.我需要按橙色对每一列进行排序，然后将行名复制到新的工作表中.

The cells between each row and column are different colors. I need to sort each column by the color orange and then copy the row names to a new sheet.

所以最后我会得到一个这样的表:

So in the end I would have a sheet like this:

| Job1 | Job2 |
| Job1 | Job4 |
| Job1 | Job5 |
| Job2 | Job3 |
| Job2 | Job5 |

这个想法是，如果您可以执行Job1，则应该可以访问Job2.这是由第一张纸上的行与列之间的交点确定的.尝试用一张纸来显示名称而不是颜色.总共有83个工作，因此手动执行此操作将使我复印4000多个.

The idea is if you can do Job1 you should have access to Job2. That is determined by the intersection between column and row from the first sheet. Try to have a sheet that shows the names instead of the colors. In all there are 83 jobs so manually doing this would have me copying over 4000.

有人知道如何创建一个宏来一次通过彩色一列自动过滤并将A1列中的行内容复制到新工作表中的方法吗?

Does anyone know how to create a macro to autofilter by color one column at a time and copy the contents of the row in column A1 to a new sheet?

推荐答案

我最终制作了一个Web界面并将所有内容转换为SQL数据库.因此，SQL数据库和逻辑可以完成所有这些工作，而不必尝试在类固醇上使用excel.

I ended up making a web interface and converting everything over to a SQL database. So the SQL database and logic could do all this instead of trying to put excel on steroids.

这篇关于将按颜色过滤的行复制到新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！