将数据从工作簿复制到另一个工作簿

Does anyone have the Macro code for copying from one excel workbook sheet data's to another excel workbook sheet but that should be date and time conditioned?
ex:

有没有人有宏代码从一个Excel工作簿工作表数据复制到另一个Excel工作簿表,但应该是日期和时间条件?例如:

Date         Time      Fruits
4/22/2009    7:30:34   Apple
4/22/2009    7:30:37   Orange
4/22/2009    7:31:19   Mango
4/22/2009    7:31:37   Grapes
4/22/2009    7:32:37   Banana
4/22/2009    7:33:37   xyz
4/22/2009    7:34:37   ABC

Here I need to copy from 4/22/2009 7:30:37 to 4/22/2009 7:33:37 fruits information to another workbook sheet including date and time. Please.

在这里,我需要从4/22/2009 7:30:37到4/22/2009 7:33:37将水果信息复制到另一个工作簿表,包括日期和时间。请。

1 个解决方案

#1

You could try the built-in Advanced Filter function to achieve that.

您可以尝试使用内置的高级过滤功能来实现这一目标。

In Excel 2007 - Data > Sort & Filter > Advanced

在Excel 2007中 - 数据>排序和筛选>高级

In Excel 2003 - Data > Filter > Advanced Filter

在Excel 2003中 - 数据>过滤器>高级过滤器

#1