If and copy function

[Lins]

I am trying to make a macro to do the following:
If a1 cell equals x copy b1:b5 to new work sheet.

Is this possible with just using functions or do I need a macro
Any help please

[Fotis1991]

If this is your only condition, then in your other sheet B1, use this and copy down to B5

Please Login or Register  to view this content.