使用条件要求自动将日期行移动到其他选项卡 [英] Automatically Move Rows of Date to other tabs using criteria requirements

问题描述

我需要移动到同一文档中的多个选项卡，我有几行数据。

I have several Rows of data that I need to move to several tabs within the same document.

这是我需要代码为我做的一个例子;我怎样才能在主标签上找到一个按钮来为我做这个？

Here is an example of what I need the code to do for me; how can I get a button on the main tab to do this for me?

如果一行

在F栏中包含"RIC"并包含  <的日期范围/ span> 1/21/2008至H列当前，

Contains "RIC" in column F and contains a date range from  1/21/2008 to Current in column H,

  ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
将数据从A列移动到I，每行与选项卡"RIC 08"匹配，从单元格G6到O6开始，向下移动每个额外的行

                Move data from column A to I of that each row that matches to tab "RIC 08" starting with cells G6 to O6 and down for each additional row

F列中包含"RIC 1.2"，日期范围为5/1/09至12 / 11/2011在H栏中，

        &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
将数据从A列移动到J，每行匹配到选项卡"RIC 1.2 MAY.09"，从单元格G6到P6开始，向下移动每个附加行

                Move data from column A to J of that each row that matches to tab "RIC 1.2 MAY.09" starting with cells G6 to P6 and down for each additional row

在F栏中包含"RIC 1.2"并包含从12/12/2011到当前H列的日期范围，

              &NBSP;&NBSP;
将数据从A列移动到J，每行匹配到选项卡"RIC 1.2 DEC.11"，从单元格G6到P6开始，向下移动每个附加行

                Move data from column A to J of that each row that matches to tab "RIC 1.2 DEC.11" starting with cells G6 to P6 and down for each additional row

在F列中包含"RIC 1.6"并包含一个日期范围
  9/1/2012至H列中的当前，

Contains " RIC 1.6" in column F and contains a date range from  9/1/2012 to Current in column H,

<跨度> <跨度> <跨度>&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
将数据从A列移动到I，每行与选项卡"RIC 1.6"匹配，从单元格G6到O6开始，向下移动每个额外的行

                Move data from column A to I of that each row that matches to tab "RIC 1.6" starting with cells G6 to O6 and down for each additional row

推荐答案

您好，

这是讨论问题和反馈的论坛对于Microsoft Excel，我会将您的问题转移到Excel的MSDN论坛

This is the forum to discuss questions and feedback for Microsoft Excel, I'll move your question to the MSDN forum for Excel

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们推荐的原因如果发布得当，您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

这篇关于使用条件要求自动将日期行移动到其他选项卡的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！