Copy and paste cells data once another cells value meets a certain criteria

Hi I was wondering if anybody is able to help me either add to this code or suggest some other to get over a slight issue I am having?

I wish to copy an paste the value from cell B1 into cell C1 when the value in cell A1 = 1.

Using the code below it works but I have two issues with it, first the value in A1 is attached to an external source which auto updates with different values throughout the day the only way the code below works is if you run the macro manually and the value in A1 is already 1 it will then copy and paste as I am away from the computer at times and the value could update for example from 34 to 1 whilst I am away I want the copy and paste to work automatically without me manually running the macro.

The second issue is I need the code to do the same thing for cell A2,B2 & C2 all the way up-to cell A10,B10 & C10. The value 1 which triggers the copy and paste in the A cells will happen in different rows i.e. 2 then 3 at different times throughout the day.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

Regards
Gally

That has worked perfect.

Thank you for your time and help 6StringJazzer - much appreciated.

Kind Regards
Gally