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

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Takae

Well-known Member
Joined
Jul 1, 2015
Messages
748
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
748
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,471
Messages
5,831,844
Members
430,089
Latest member
beesz

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