IF statement - pull data based on criteria

[Nikhil R]

Hi team,

I need some help a little bit. Trying various methods to pull data from one table onto another table in another sheet.

For example, one Column has Interested as a header, and if Yes - to pull candidate name into another table that's on another sheet with the same header under candidate name and vice versa for post code number and email address.

If it's not clear, please let me know

 

[Nikhil R]

Try

=FILTER('Canditate Track'!A6:E100,'Canditate Track'!K6:K100="Candidate Accepted")

No doesn't work, opens a window to search for a file name

 

[Nikhil R]

No doesn't work, opens a window to search for a file name

It works, i sorted it - thank you buddy

 

[Fluff]

You're welcome.

 

[Nikhil R]

So I've been tinkering with the Filter & Choosecols filter as I've created a sheet called Rejected Candidates. It's like for like as shown on the Interested Candidates sheet.

I've got it so it copies everything onto rejected candidates sheet IF rejected is shown as yes on interested candidates - but i need it to remove that row. so essentially cut from interested candidates sheet, and pasted onto rejected candidates sheet if rejected is "yes"

I did have another formula which was =FILTER but it did the same thing as the one below

=CHOOSECOLS(FILTER(Interested_Candidates,Interested_Candidates[Rejected]="yes"),MATCH(A5:M5,Interested_Candidates[#Headers],0))

 

[Fluff]

A formula cannot remove data from another sheet, you would need VBA for that.

 

[Nikhil R]

A formula cannot remove data from another sheet, you would need VBA for that.

I see, i did have a look and yeah VBA is needed. I noticed Excel has VBA built in - now I need to figure out how to code it as used VBA years ago and extremely rusty

 

[Fluff]

If you need help with it, you will need to start a new thread. Thanks