VBA Copy Sheet and and Different Cell to each copied sheet

I am very new to VBA programing and I would like some help. I want to copy a sheet x number of times and copy a different cell to each copied sheet. I have a code that will copy the sheet but I need help writing some code to copy a cell to each sheet. Let me try to explain a little better.

Lets say I have something in cells A1:A5. I would want to make 5 copies of sheet2 and copy A1 to the first sheet, copy A2 to the second sheet, A3 to the third sheet and so forth.

See my code for copying the sheets below.

Please Login or Register  to view this content.

Thank you

Hi,

like that?

Please Login or Register  to view this content.

Regards

Theo

Thank you Theo, But it didn't seem to work. The code you gave still copies the sheet but it doesn't copy a cell to each page. I have text in cells A1, A2, A3, A4, and A5. I want to make 5 copies of sheet2 and copy A1 to the first copy, A2 to the second copy, A3 to the third and so on. Do you have any ideas?