Scrolling Race Results

Excel Help for Scrolling Race Results in Presenting and Reporting Data

Scrolling Race Results

Rate this: (3/5 from 1 vote)

	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 OD92fs on 12 Nov 2014

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Scrolling or target range 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 Excel Helper on 13 Nov 2014

Displaying page 1 of 1