Filter and copy

[rizmomin]

Hello:

I have data in sheet1 (from Row 6 onwards)Column A thru F with
Column A is YEAR (Example : 2001,2002, etc)
Column B is Date (Example : 12/11/2001, etc)
Column C thru F other data.

Sheet 2: Cell A1 would have drop down list of years from 2001 thru 2013

I need VB Macro to copy all data from Sheet1 to Sheet2 (statring in Row6) for a year value from Sheet2 Cell A1.


Please let me know if any questions.

Thank you

Riz Momin

[MarvinP]

Hi Riz,

Here is a sample that I think you can expand on.
This example uses a Dynamic Named Range on Sheet1.
It then does an Advanced Filter on Sheet 2
That is triggered by changing the number in cell A1 on sheet 2.

See if it isn't what you are looking for.

[rizmomin]

Hi Marvin:

Excellent, this will work for me.

Thank you so much for your great help.

Riz Momin

[rizmomin]

Hi: Marvin

How do i define my data in the code.

Please help.

Thank you

Riz Momin

[rizmomin]

Hi Marvin:

Please refer to my attached sheet and see if you help.

Thank you

Riz Momin

[AB33]

Riz,
Try the attached. The code will be triggered by changing the value of A1.
I make certain assumptions:

You want to clear the existing data before you copy the new data, but if you do not want that, i.e. if you want to copy in to next empty cell, please comment the line which clears data.

Please Login or Register  to view this content.

I am not sure if you also want to delete the copied data once they are copied in to filter sheet. I have commented a line (Green line). If you want it, you can uncomment it and data will be deleted from sheet1.

[rizmomin]

Hi AB33:

This works perfectly with my data.
Thank you so much for your great help.

Riz Momin

[rizmomin]

Hi AB33:

This works perfectly with my data.
Thank you so much for your great help.

Riz Momin

[AB33]

Riz,
You are always welcome!