Copy cell next to IF-statement- cell??

[paljako]

Hi,

I wan't to extract some data from a table with various years (9,10,11,12), but only for one year at a time. I want to make a makro that can extract the data from for example 2011. The year number is in column U, the data i vant to extract is in column T and S.

Do anyone have a idea of how to solve this?

I think it should be something like this:

Please Login or Register  to view this content.

Tor

[bonny24tycoon]

Can you upload an example workbook with some comments?

[paljako]

Sorry, I'm at work and we have a very strict firewall here wich i can't turn off. I can upload it later when i get home.

but its like this:

S T U
4 Name Value 2011
5 Name Value 2010
6 Name Value 2011
.
.

I wan't to extract the Names and values from year 2011 and copy it into another table .

[Cutter]

@ paljako

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.