I have several columns and want to split the data based upon a single column into multiple worksheets.
I have several columns and want to split the data based upon a single column into multiple worksheets.
good for you. :o)
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
What nathansav is getting at is we have no idea about the specifics. This code below does exactly what your posts says but I have no idea if it will actually work for you.
![]()
Sub RunMe() Dim wksht As Worksheet: Set wksht = Sheets("Sheet1") Dim ws As Worksheet Dim icol As Integer For icol = 1 To Cells(1, Columns.Count).End(xlToLeft).Column wksht.Columns(icol).Copy Set ws = Sheets.Add(After:=Sheets(Sheets.Count)) ws.Columns(1).PasteSpecial xlPasteAll Next icol End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks