Related:
- One column multiple rows (data in sets)
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to insert multiple rows in microsoft excel - Guide
- Data transmission cable - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 22, 2010 at 05:30 PM
May 22, 2010 at 05:30 PM
Try this Olivia. It will take some time as you got just too many rows.
Sub MoveSelection()
Dim lMaxRows As Long
Dim iCol As Integer
lMaxRows = Cells(Rows.Count, "A").End(xlUp).Row
iCol = 2
If (lMaxRows / 22 > Columns.Count - 1) Then
MsgBox ("Data cannot fit in available columns. It needs " & lMaxRows / 22 & " columns where as only " & Columns.Count & " are available")
Exit Sub
End If
Do While lMaxRows >= 22
iCol = iCol + 1
Range(Cells(1, iCol), Cells(22, iCol)) = Range(Cells(23, 2), Cells(44, 2)).Value
Rows("23:44").Delete
lMaxRows = Cells(Rows.Count, "A").End(xlUp).Row
Loop
End Sub
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 22, 2010 at 03:21 AM
May 22, 2010 at 03:21 AM
Are you saying that you have all the data in one column and you would like to move it to columns.
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
I have a similar problem, except my data stretches across the rows and I would like to break it down under one "Class" column but still keep the data with the person's name.
First Name, Last Name, ID, Class One, C1 Instructor, Class Two, C2 Instructor, Class Three, C3I
Is there a way to place class 2, C2I, and class 3 with C3I on the next couple of lines under the students' respective names throughout my 1000+ line spreadsheet?
Thank you.
lkc
First Name, Last Name, ID, Class One, C1 Instructor, Class Two, C2 Instructor, Class Three, C3I
Is there a way to place class 2, C2I, and class 3 with C3I on the next couple of lines under the students' respective names throughout my 1000+ line spreadsheet?
Thank you.
lkc
