Macro to copy cells from one column to multiple sheets

[jonathansd]

Hi guys,
I need to create a macro to copy cells from a column to multiple sheets. For example, i need to copy
A1 from sheet0 to sheet1,
A2 from sheet0 to sheet2,
A3 from sheet0 to sheet3 etc
What i need to do is sort of a reverse summary
I need to do this for 1000 sheets. I am using Excel 2013
Hope you guys can help.

 

[jonathansd]

The macro works great to copy the data into .cells(2, 2).
I can not seem to get it to write data into .cells(2, 3) which is B3
The macro runs, but no changes are made

 

[jonathansd]

I can get it to write on D4 .Cells(4, 4), but not on B3

 

[jonathansd]

Sample.xlsx - Speedy Share - upload your files here

Here is a sample of what i am trying to do.

 

[jonathansd]

After rebooting it seems to work. Weird.

 

[venkat1926]

you are welcome. but remember when a macro is give by somebody to you, you should go through the code statements one by one and edit them to suit your needs.