Hi

I hope someone can help. I am looking for a macro that can loop through column A and look for the the cell value beginning with "275X" and then copy the cell values in column A to each worksheet in the workbook.

So if column A has 275X105 in A6 and 275X112 in A7 then worksheet 2 cell B3 should be updated to say 275X105 and worksheet 2 cell B3 will have 275X112 and so on and so forth.

Many thanks all in advance.

S