Column to sheet copy

varunmol

New Member
Joined
Sep 6, 2016
Messages
21
Hi Everyone,

I am not good with excel.

I have a simple question, I hope!!
  1. I have some data in the first column of a sheet.
  2. I want to put this data in different sheets.
So simpling put if I have names of people in the first column of the first sheet
  1. Bob
  2. Jane
  3. Jani
I want the first name in the first column of sheet 2
The second name in the first column of sheet 3 and so on.

Hope I m clear, looking forward to any suggestion
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Takae

Well-known Member
Joined
Jul 1, 2015
Messages
726
Does the data on sheet1 start from the first line? Also, do you want to paste it on each sheet A1?
VBA Code:
Sub test()
Dim i As Long

For i = 2 To Worksheets.Count
    Sheets(i).Range("A1").Value = Sheets("Sheet1").Cells(i - 1, 1).Value
Next
MsgBox "Done"
End Sub
 

varunmol

New Member
Joined
Sep 6, 2016
Messages
21
Does the data on sheet1 start from the first line? Also, do you want to paste it on each sheet A1?
VBA Code:
Sub test()
Dim i As Long

For i = 2 To Worksheets.Count
    Sheets(i).Range("A1").Value = Sheets("Sheet1").Cells(i - 1, 1).Value
Next
MsgBox "Done"
End Sub
hi

thank you for your reply, yes

but there are multiple entries so


1st column in sheet 1
2nd column in sheet 2
and so on...

sorry but I don't know how to use VBA
 

Takae

Well-known Member
Joined
Jul 1, 2015
Messages
726
2nd column in sheet 2?
My code runs like this.
  1. Bob ---paste to sheet2 of A1
  2. Jane---paste to sheet3 of A1
  3. Jani---paste to sheet4 of A1
Please save your file then test my code.
Press [Alt+F11] . You can see VBE and press [Alt] -[ I ] -[M] one by one.
Module1 will be displayed. Paste my code into Module1. Click anywhere between Sub() to End sub , and press F5.
 

varunmol

New Member
Joined
Sep 6, 2016
Messages
21
2nd column in sheet 2?
My code runs like this.
  1. Bob ---paste to sheet2 of A1
  2. Jane---paste to sheet3 of A1
  3. Jani---paste to sheet4 of A1
Please save your file then test my code.
Press [Alt+F11] . You can see VBE and press [Alt] -[ I ] -[M] one by one.
Module1 will be displayed. Paste my code into Module1. Click anywhere between Sub() to End sub , and press F5.
let me try to thank you so much this is a big help
 

Forum statistics

Threads
1,148,340
Messages
5,746,186
Members
423,998
Latest member
eakenila

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top