Macro for auto filter & Copy to new workbook

[learningkid0808]

Dear VBA Guru’s,

I am looking for a VBA Code to smoothen the below process.

I have a workbook called Dept. queries and it contains two sheets 1. Data (updated on daily basis) 2. Dept ( Contains Dept. Names)

Based on the sheet 2 (Dept names) Macro needs to autofilter the exact dept name on sheet (Data) and copy. (Note: Dept. names can be added if there is a new dept. added)

Copy destination would be the workbook I have already created workbook in the same folder with the same dept name.

I have attached the workbook for your reference.

Appreciate Immediate help on this !!!!!

[apo]

Hi..

This will do it..

You need to change the file path to suit you.. (change C:\Departments\ to where you have the files on your PC)

Please Login or Register  to view this content.

[learningkid0808]

Hi.... APO....

One more help on this code, copy destination ensure that the previous details should be deleted before pasting the new values.

Thank you for your immediate help....

Hi..

This will do it..

You need to change the file path to suit you.. (change C:\Departments\ to where you have the files on your PC)

Please Login or Register  to view this content.

[apo]

Hi..

One more help on this code, copy destination ensure that the previous details should be deleted before pasting the new values.

Currently, it appends the data to the next available row..

If you want to clear the data on each sheet before adding fresh data..

After this line:

Please Login or Register  to view this content.

Add this..

Please Login or Register  to view this content.

[learningkid0808]

[SOLVED]Thank you every one for your quick help on this.... this is really motivating me to learn things faster

[learningkid0808]

Hi APO.....
After using the macro multiple times found that, it would be very helpful if the macro read the path from the cell value on list tab. Cell.value"F4"

[apo]

Hi..

How about Browsing for the Folder using a Browse Dialogue...

Please Login or Register  to view this content.

Note: It will also store the most recent folder selection in your Dept sheet..

[learningkid0808]

Thanks a lot..... APO.... This was really helpful.....