Hoping someone can help me out.

I have a list of data in column A.

This list grows every week.

Is there a way I can paste a link to another worksheet that lists the first and last 100 entries of this column into 2 seperate columns automatically.

I will then try to run 2 sample t testing off this data.
This saves me having to recreate the ranges everytime the data list grows and the test is run.

Thanks for any help given.