Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Off Topic > Off Topic - Computers


Reply
 
Thread Tools Rate Thread
Old 05-26-2018, 11:58 PM   #1
Dave Schwartz
 
Dave Schwartz's Avatar
 
Join Date: Mar 2001
Location: Reno, NV
Posts: 16,877
Amazing Excel Add-in: DataPig Excel Explosion

Several people have asked in recent days about how to move data around in Excel. Fraser Rawlinson suggested this product and, based upon his recommendation, I just went ahead and blew the whole $14.95.

I've not even used it yet but the functions sound truly wonderful.

Split your Data into Separate Tabs
Split your Data into Separate Workbooks
Exploding Access and SQL Server Data
Automating Excel Explosion via VBA



First, just the DataPig Articles are amazing (although the website is a little rough).


Here is a link to the add-on: DataPig Excel Explosion.
Dave Schwartz is online now   Reply With Quote Reply
Old 05-27-2018, 02:49 AM   #2
NorCalGreg
Authorized Advertiser
 
NorCalGreg's Avatar
 
Join Date: Dec 2014
Location: Oakland, Ca
Posts: 7,953
Any help I can be.....let me know, please.
NorCalGreg is offline   Reply With Quote Reply
Old 05-30-2018, 09:13 AM   #3
Tom
The Voice of Reason!
 
Tom's Avatar
 
Join Date: Mar 2001
Location: Canandaigua, New york
Posts: 112,470
Looks like a good site, but I am not able to view anything because I will not use Flash Player. Anyone have a suggestion for a work-around, or am I forced to use a bad device? I tried to save link as, but it won't work.
__________________
Who does the Racing Form Detective like in this one?
Tom is offline   Reply With Quote Reply
Old 07-19-2018, 02:33 PM   #4
highnote
Registered User
 
highnote's Avatar
 
Join Date: Feb 2002
Posts: 10,861
Quote:
Originally Posted by Tom View Post
Looks like a good site, but I am not able to view anything because I will not use Flash Player. Anyone have a suggestion for a work-around, or am I forced to use a bad device? I tried to save link as, but it won't work.
I have several browsers installed. I only have flash on one of them and will use that browser if I need to watch a flash formatted video. Pain in the ass.
highnote is offline   Reply With Quote Reply
Old 07-19-2018, 03:09 PM   #5
DeltaLover
Registered user
 
DeltaLover's Avatar
 
Join Date: Oct 2008
Location: FALIRIKON DELTA
Posts: 4,439
Flash? Let it die please!
__________________
whereof one cannot speak thereof one must be silent
Ludwig Wittgenstein
DeltaLover is offline   Reply With Quote Reply
Old 07-20-2018, 09:55 AM   #6
mikesal57
Veteran
 
mikesal57's Avatar
 
Join Date: Sep 2003
Location: NEW YORK CITY
Posts: 3,670
Code:
Sub Sort()
Dim lastrow As Long, LastCol As Integer, i As Long, iStart As Long, iEnd As Long
Dim ws As Worksheet
Application.ScreenUpdating = False
With ActiveSheet
    lastrow = .Cells(Rows.Count, "A").End(xlUp).Row
    LastCol = .Cells(1, Columns.Count).End(xlToLeft).Column
    .Range(.Cells(2, 1), Cells(lastrow, LastCol)).Sort Key1:=Range("X2"), Order1:=xlAscending, _
        Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    iStart = 2
    For i = 2 To lastrow
        If .Range("X" & i).Value <> .Range("X" & i + 1).Value Then
            iEnd = i
            Sheets.Add after:=Sheets(Sheets.Count)
            Set ws = ActiveSheet
            On Error Resume Next
            ws.Name = .Range("X" & iStart).Value
            On Error GoTo 0
            ws.Range(Cells(1, 1), Cells(1, LastCol)).Value = .Range(.Cells(1, 1), .Cells(1, LastCol)).Value
            .Range(.Cells(iStart, 1), .Cells(iEnd, LastCol)).Copy Destination:=ws.Range("A2")
            iStart = iEnd + 1
        End If
    Next i
End With
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub
Guys...

This will take an excel sheet and sort it by what ever column you want...
In this example...I had all tracks mixed up in one whole sheet...
After i ran this macro, I now have Tracks sorted by tabs(see bottom)...
Just replace the "X" with whatever column you want to break out

enjoy
Mike

Attached Images
File Type: jpg Untitled.jpg (363.3 KB, 23 views)
mikesal57 is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 01:39 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright 1999 - 2023 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.