Home > Forum Home > Presenting and Reporting Data > Scrolling Race Results Share

Scrolling Race Results

Excel Help for Scrolling Race Results in Presenting and Reporting Data


Forum TopicPost Reply Login

Scrolling Race Results

Rate this:
(3/5 from 1 vote)
Confused Hi All,

I've been trying to wrap my head around a way to display vertically-scrolling race results (sort of like movie credits). The closest I've been able to find to what I want is the solution at the following link: [http://www.ozgrid.com/forum/showthread.php?t=147337]

The code in the document at that link takes particular columns on the sheet and displays the info in a stock ticker on the same sheet. What I would like to do is very similar, except I want data from a specific (unopened) CSV to scroll vertically in a separate workbook, with about 25 rows of data showing at any given time.

To be a bit more detailed, below are links to a sample of the kind of source CSV and a template of what the ideal display would look like.

Any help is greatly appreciated!

https://drive.google.com/file/d/0B6h...ew?usp=sharing

https://drive.google.com/file/d/0B6h...ew?usp=sharing


Is this too far-fetched? Any pointers?

Thanks!

-Ben
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Shocked
Rate this:
(3/5 from 1 vote)
To scroll a workbook at a specific speed we can use VBA with the Sleep function to delay ActiveWindow.ScrollRow. However it seems that you need to simply link to a specif range in a separate workbook in which case we can simply use Windows("workbook_name").Sheets("sheet_name").Range("top_cell").Select.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Scrolling Race Results in the