Hi All -

I have a list of regions on one worksheet, say cells A10:A50, and I have 40 other worksheets in the same workbook. Starting with the first value in the list, I want to copy it to cell A1 on the first worksheet, and so on so that each of the other worksheets has one unique value in cell A1.

Can someone please help me with code for this?