Filtering data and pasting into another workbook (v2.0)

[longbow007]

Hello, could some one please help me with the following:

I need an Excel 2003 macro to automatically filter data in my workbook named: Manufacturing Spares Inventory.xls (worksheet named: Z-1) and to copy the filtered data and paste it into another open workbook named: 4-3-2-1 Report.xls (worksheet named: 1 Mth).

The filtering criteria is as follows:

First Filter column AN

All those dates greater to or equal than today's date and

All those dates less than or equal to today's date + 30

Second Filter column AQ

All those values equal to VACANT

The results of these two filters needs to be copied and pasted into:

another open workbook named: 4-3-2-1 Report.xls (worksheet named: 1 Mth) cell A3.

I have tried using the Excel Macro recorder but to no avail.

Please note that the results of these two filters may vary and thus the amount of rows to be copied and pasted will vary accordingly.

As an example:

I have attached both workbooks.

I used today's date: 26 May 10 and today's date + 30 (which was 25 Jun 10).

The results of the above are shown in the 4-3-2-1 Report.xls workbook.

Any assistance is greatly appreciated.

Kind regards,

Chris

[longbow007]

Hello, could some one please help me with the following:

I need an Excel 2003 macro to automatically filter data in my workbook named: Manufacturing Spares Inventory.xls (worksheet named: Z-1) and to copy the filtered data and paste it into another open workbook named: 4-3-2-1 Report.xls (worksheet named: 1 Mth).

The filtering criteria is as follows:

First Filter column AN

All those dates greater to or equal than today's date and

All those dates less than or equal to today's date + 30

Second Filter column AQ

All those values equal to VACANT

The results of these two filters needs to be copied and pasted into:

another open workbook named: 4-3-2-1 Report.xls (worksheet named: 1 Mth) cell A3.

I have tried using the Excel Macro recorder but to no avail.

Please note that the results of these two filters may vary and thus the amount of rows to be copied and pasted will vary accordingly.

As an example:

I have attached both workbooks.

I used today's date: 26 May 10 and today's date + 30 (which was 25 Jun 10).

The results of the above are shown in the 4-3-2-1 Report.xls workbook.

Any assistance is greatly appreciated.

Kind regards,

Chris

Please review my simple VBA code:

Please Login or Register  to view this content.

Also, please find attached an example of how my code filters the data in the Manufacturing Spares Inventory.xls workbook. As you can see, the filtered data is not visible and therefore the following code does not work properly:

Please Login or Register  to view this content.

I do not understand why the filtered data is not visible

Any help on this matter would be greatly appreciated