How to randomly choose a starting point but with a fixed data size from a column of data

I have a column of data (1300 data values) and need to to calculations based on randomly choosing a starting point amongst the data cells with a fixed end (lets say 100 cells).....the order matters......once I can retrieve the data points onto another column I can do my calculations. So for example, I need to have excel retrieve 100 data points in order of how they appear, but randomly starting at one of the cells in the column then going down 99 more cells....and place those 100 data points in other column for analytics. Anyone have a solution?

Hi! Check the VBA code in the file attached. I think the code performs the task that you need. Hope it helps!

I can't open the xlsm file on my work computer. Can you send so I can copy and paste?

Hi, this is the code:

Please Login or Register  to view this content.

Column A has the numbers, with a header in A1. In column B you get the results (also header in B1). Finally, a button to run the macro.

ScreenShot.JPG

I can't debug this portion
Range("B1").Offset(X, 0).Value = Range("A1").Offset(StartPos + X - 1).Value

The code works fine on my computer. Download this version, may be you can open it an then save is as a file with macros.

A shorter version taking into account protonLeah's contribution:

Please Login or Register  to view this content.

Thank you so much excel_bat and protonLeah. It worked like a charm.