Help with Filter! - Macro

[moi2185]

Hi all, I'm an excel newbie trying to filter a data in column AF using the criteria as "Not assigned" and then copy just the unique values in column V (this data will be paste in another sheet called "Tool" cell H29). I know that I can go and copy the data paste it and then use the remove duplicates function but I think that there should be a more efficient way to get it done.

By the way this is runned into a macro, so any VB code will be greatly appreciated.

Best regards,

Moises G.

 

[GlennUK]

Have you tried using Advanced Filter? Set up a criteria area, with the same heading as column AF, with a single cell under it with "Not assigned", and set up an output area, with the column V and AF headings. Do this in the same sheet when testing ... see if does what you want ( tick the Unique Records Only tickbox ). If that does what you want, then record a macro of the action, and tweak the code, so that it extracts directly to the "Tool" sheet.

 

[moi2185]

Have you tried using Advanced Filter? Set up a criteria area, with the same heading as column AF, with a single cell under it with "Not assigned", and set up an output area, with the column V and AF headings. Do this in the same sheet when testing ... see if does what you want ( tick the Unique Records Only tickbox ). If that does what you want, then record a macro of the action, and tweak the code, so that it extracts directly to the "Tool" sheet.

Thanks for your reply. I tried but it didn't work. What should I put under the AF column?

 

[GlennUK]

Thanks for your reply. I tried but it didn't work. What should I put under the AF column?

Er, do you mean, what should you put under the criteria heading that has been copied from the AF column? ( the AF Column contains your original data doesn't it )

If that's what you mean, then type
Not assigned
into the cell under the heading, and refer to the heading and that cell as the Criteria.