Loop macro displaying only certain cells and keeping their format

Hello all!

This is my first thread so I hope I'll be clear enough.

I attached a template so as to visualise my work.

I would like to create a loop doing the following work:

If INPUT!A2="IVR" then display Input!B2 in Audio!A2 with the same format.
If not, then check Input!A3 and so on.

At first I thought I could just put in Audio!A2 a simple If function like IF(Input!A2="IVR",Input!B2,""), but if I do so I have two major problems in my Audio sheet:

1) The format (colours) is lost. (colours are crucial for what I want to do because they symbolise languages for a translation company)
2) I have a lot of blank cells that I don't want. I would like to have only the IVR cells displayed in my "Audio" sheet.

Thank you very much in advance for your help!

Antoine

Thank you for your answer Pierre! It works perfectly!
Just one more thing, how would I do if I want to display these content in the column B of the Audio sheet and not in column A?

Thanks again!

In fact, I would like to also do the exact same thing and copy any IVR reference in column C of the "Input" sheet to column B of the "Audio" sheet.

If I redo the code you gave me and change Cell.Offset(0,1).copy by Cell.Offset(0,2).Copy it copies the content as I want but put it under the column A as well...

Would you or anyone have a clue?

I posted a new file for you to see.

Thanks,

Antoine

Thank you so much Pierre, I used the second suggestion of macro and it is working brilliantly!
My last question would be: would there be a way to make it autmatic (not to have to clear content and apply the macro in sheet 3 each and every time sheet 1 is modified)?

All the best,

Antoine

Yes I think you are right, it might be too risky for the system. And anyway it is not time consuming to click on the macro button, and it enables a certain QA as well.

Thanks again for everything!

All the best,

Antoine