Copy info from Master tab to other tabs based on conditions

Hi all

I am very new to this forum so please forgive me if I have posted in the incorrect place.
My knowledge of excel is limited so if anyone is able to help me out, I would appreciate it!

I have a master worksheet. with "X" in certain columns. what I need now is for something automated...

If there is not an "X" in column E ,I would the information in column B&C of that row to copy to another sheet(Cred app OS).

And exactly the same for column F, G,and H to their own individual sheets.

Hope it is clear!


Sorry what I meant was that within column F(Debtors Master), all rows that do not contain an "X" the info from Column B&C is to be copies to the tab "Credit App OS".

Then for Column G(Debtors Master) all rows that do not contain an "X" the info from Column B & C is to be copies to the tab "VAT Cert OS".

Then for Column H(Debtors Master) all rows that do not contain an "X" the info from Column B & C is to be copies to the tab "Accs to close".

Then if in Column E,F,G,H (Debtors Master) there are no "X"s in any of these columns, the information from that specific row is to be copied to the tab "No Apps Sent".

I hope this is not a difficult request, however with excel im sure its possible, I just do not have the knowledge as yet.

Also All this bearing in mind that on the Debtors Master tab the information will be changed regularly and inturn update the other tabs at the same time.

Thank you

Thank you but I have no idea how the formular works, please can you explain a little more or else insert it into my excel workbook.