Copy rows in sheet if certain cell contains text

[paulsmith2710]

Hi, could you help me with this problem please.

I have an excel file with x4 sheets.

1st = MASTER - this will contain hundreds of rows of data and in column A, it will be populated with A, B or C
2nd = Sheet A
3rd = Sheet B
4th = Sheet C

Is there a formula (rather than a VBA or Macro as I have no experience of these) that can be implemented into Sheet A B & C that will automatically copy the relevant row from the Master spreadsheet (using A B or C in the A column) into each of these?

Unfortunately, I can't currently upload a test file due to my work place security.

Thank you

Paul.

[Fluff13]

How about

Please Login or Register  to view this content.

[paulsmith2710]

Hi thankyou... sorry, I'm struggling to make this work?

[Fluff13]

In what way?

[paulsmith2710]

Hi Fluff13, sorry ignore me, your formula is perfect, thanks very much (very impressed!)

[Fluff13]

Glad to help & thanks for the feedback.