Applying filters

**jimz** · 09-10-2011, 03:48 PM

Hi,

Require help in below.

Please Login or Register  to view this content.

the above code allows me to copy the data to sheet2 "the code is huge so not able to past every thing"

Please Login or Register  to view this content.

'now appling the filter crateria on the sheet2 and past the data on sheet3
till here have no problem

now after data is pasted on the sheet 3 from sheet 2 i need to go back to the sheet 2 change filter criteria and past the data to sheet4. which i am not able to do so.

Also need copy some columns only from sheet2 but the entire sheet gets pasted to the sheet3

Please Login or Register  to view this content.

The problem is i need to copy the data from sheet2 to sheet3 sheet4 sheet5 and sheet6 with different filter Criteria.

I also need to copy only some specific columns from sheet2 to sheet3.

please can some one help me it is urgent ......

**jaslake** · 09-13-2011, 07:10 PM

Hi jimz

Welcome to the Forum.

The code in the file you posted references Column F several times looking for values such as "Americas" and "AP" etc. yet Column F is empty in all worksheets.

It would appear, based on the code, the file you posted doesn't represent your "real" data

**jimz** · 09-14-2011, 07:49 AM

Originally Posted by jaslake

Hi jimz

Welcome to the Forum.

The code in the file you posted references Column F several times looking for values such as "Americas" and "AP" etc. yet Column F is empty in all worksheets.

It would appear, based on the code, the file you posted doesn't represent your "real" data

Thanks John for your replay but code that i have mentioned is not related to the file that i have attached. the original information is sensitive so can not attache or revile it here . logic is same as in the above code and the question remains the same as i have asked in the previous quote

.....................................................................