Hello guys,

I hope you'll can help me. i have the information below in sheet 1. i
need the information to be filtered, copy and paste in sheet 2
according to the month. example. if october, i need all information
for the month of october to be copy and past from column A, B, C sheet
1 to column A, B, C sheet 2 please help.

A B C
Serial Number Quantities (Kilos) Date
8.1122 539,470 22/10/2009
8.1122 403,697 22/10/2009
8.1122 643,710 05/11/2009
8.1122 1,036 05/11/2009
8.1122 221,183 12/11/2009
8.1122 21,467 26/11/2009
8.1122 633,650 26/11/2009
8.1122 320,275 03/12/2009
8.1123 46,760 22/10/2009
8.1124 288,700 15/10/2009
8.1124 191,160 05/11/2009
8.1125 111,624 01/10/2009
8.1125 50,712 01/10/2009
8.1125 247,788 01/10/2009
8.1125 5,062 01/10/2009
8.1125 14,328 08/10/2009
8.1125 830,862 08/10/2009
8.1125 21,276 15/10/2009
8.1125 4,918 15/10/2009
8.1125 1,330,130 15/10/2009
8.1125 123,957 22/10/2009
8.1125 415,584 22/10/2009
8.1125 1,224,941 22/10/2009
8.1125 137,391 29/10/2009
8.1125 596,337 29/10/2009
8.1125 255,558 29/10/2009
8.1125 463,906 05/11/2009
8.1125 21,160 12/11/2009
8.1125 584,899 12/11/2009
8.1125 138,210 19/11/2009
8.1125 884,119 19/11/2009
8.1125 137,233 26/11/2009
8.1125 669,902 26/11/2009
8.1125 1,128,757 03/12/2009
8.1125 1,267,186 03/12/2009
8.1126 29,190,000 01/10/2009
8.1126 26,670,000 12/11/2009
8.1126 30,190,000 03/12/2009
8.1127 8,928,000 08/10/2009
8.1127 118,156 08/10/2009
8.1127 6,282,000 15/10/2009
8.1127 9,748,000 15/10/2009
8.1127 3,728,000 05/11/2009
8.1127 8,273,000 12/11/2009
8.1127 70,637,000 19/11/2009

You could put this formula in D2:

=MONTH(C2)

and copy this down. Then you could apply your filter to column D, and
select 10 from the filter pull-down. Then <copy the visible cells and
<paste into sheet 2.

Hope this helps.

Pete

On Dec 5, 12:12*am, dave wrote:
Hello guys,

I hope you'll can help me. i have the information below in sheet 1. i
need the information to be filtered, copy and paste in sheet 2
according to the month. example. if october, i need all information
for the month of october to be copy and past from column A, B, C sheet
1 to column A, B, C sheet 2 please help.

A * * * * * * * * * * * B * * * * * * * * * * * C
Serial Number * Quantities (Kilos) * * *Date
8.1122 * * * * * * * * *539,470 * * * * * * * * 22/10/2009
8.1122 * * * * * * * * *403,697 * * * * * * * * 22/10/2009
8.1122 * * * * * * * * *643,710 * * * * * * * * 05/11/2009
8.1122 * * * * * * * * *1,036 * * * * * * * * * 05/11/2009
8.1122 * * * * * * * * *221,183 * * * * * * * * 12/11/2009
8.1122 * * * * * * * * *21,467 * * * * * * * * *26/11/2009
8.1122 * * * * * * * * *633,650 * * * * * * * * 26/11/2009
8.1122 * * * * * * * * *320,275 * * * * * * * * 03/12/2009
8.1123 * * * * * * * * *46,760 * * * * * * * * *22/10/2009
8.1124 * * * * * * * * *288,700 * * * * * * * * 15/10/2009
8.1124 * * * * * * * * *191,160 * * * * * * * * 05/11/2009
8.1125 * * * * * * * * *111,624 * * * * * * * * 01/10/2009
8.1125 * * * * * * * * *50,712 * * * * * * * * *01/10/2009
8.1125 * * * * * * * * *247,788 * * * * * * * * 01/10/2009
8.1125 * * * * * * * * *5,062 * * * * * * * * * 01/10/2009
8.1125 * * * * * * * * *14,328 * * * * * * * * *08/10/2009
8.1125 * * * * * * * * *830,862 * * * * * * * * 08/10/2009
8.1125 * * * * * * * * *21,276 * * * * * * * * *15/10/2009
8.1125 * * * * * * * * *4,918 * * * * * * * * * 15/10/2009
8.1125 * * * * * * * * *1,330,130 * * * * * * * * * * * 15/10/2009
8.1125 * * * * * * * * *123,957 * * * * * * * * 22/10/2009
8.1125 * * * * * * * * *415,584 * * * * * * * * 22/10/2009
8.1125 * * * * * * * * *1,224,941 * * * * * * * * * * * 22/10/2009
8.1125 * * * * * * * * *137,391 * * * * * * * * 29/10/2009
8.1125 * * * * * * * * *596,337 * * * * * * * * 29/10/2009
8.1125 * * * * * * * * *255,558 * * * * * * * * 29/10/2009
8.1125 * * * * * * * * *463,906 * * * * * * * * 05/11/2009
8.1125 * * * * * * * * *21,160 * * * * * * * * *12/11/2009
8.1125 * * * * * * * * *584,899 * * * * * * * * 12/11/2009
8.1125 * * * * * * * * *138,210 * * * * * * * * 19/11/2009
8.1125 * * * * * * * * *884,119 * * * * * * * * 19/11/2009
8.1125 * * * * * * * * *137,233 * * * * * * * * 26/11/2009
8.1125 * * * * * * * * *669,902 * * * * * * * * 26/11/2009
8.1125 * * * * * * * * *1,128,757 * * * * * * * * * * * 03/12/2009
8.1125 * * * * * * * * *1,267,186 * * * * * * * * * * * 03/12/2009
8.1126 * * * * * * * * *29,190,000 * * *01/10/2009
8.1126 * * * * * * * * *26,670,000 * * *12/11/2009
8.1126 * * * * * * * * *30,190,000 * * *03/12/2009
8.1127 * * * * * * * * *8,928,000 * * * * * * * * * * * 08/10/2009
8.1127 * * * * * * * * *118,156 * * * * * * * * 08/10/2009
8.1127 * * * * * * * * *6,282,000 * * * * * * * * * * * 15/10/2009
8.1127 * * * * * * * * *9,748,000 * * * * * * * * * * * 15/10/2009
8.1127 * * * * * * * * *3,728,000 * * * * * * * * * * * 05/11/2009
8.1127 * * * * * * * * *8,273,000 * * * * * * * * * * * 12/11/2009
8.1127 * * * * * * * * *70,637,000 * * *19/11/2009