VBA - Move Data from one Worksheet to Multiple Sheet

[Excelnavy]

Hi Friends,
My main data in Sheet1 but i want that data in Sheet2, Sheet3, Sheet4 in VBA
For Example -
Data in Sheet1
A - 100
B - 200
C - 300
So i want this data like
Sheet2
A - 100
Sheet3
B - 200
Sheet4
C - 300
Is it possible, Please help me ?

 

[MrKowz]

Welcome to the forums!

I assume this is an overly-simplified version of your data... so I can create something much more tailored to your actual situation, could you please briefly elaborate on what exactly you are looking to accomplish?

Are these values in row 1 on sheet 1 going across columns, and you want each value to be placed in cell A1 in the other sheets (i.e 100 in A1 on Sheet2, 200 in A1 on Sheet3, and so forth)? How many of these values are being copied to the sheets? Do the sheets already exist, or will the code need to create them?

 

[Excelnavy]

Thank You for reply,
I share picture please click below link,


https://drive.google.com/open?id=0B-RgNH1fYX6HRDFUVXl4ZFdhQUE

 

[Excelnavy]