so as I add data that will automatically add the new data and drop off the
old data?


--
Jeff


"Dave Peterson" wrote:

I inserted another tab in the workbook.

Then I selected 7 vertical cells (A1:A7 or J100:J106 or whatever).

Then I pasted that formula into the formula bar.
But instead of using enter, I hit shift-ctrl-enter -- since I wanted an array of
values brought back.



Jeff wrote:

I would like to be able to create a dynamic range to pull the last seven days
of data from spreadsheet and place it in a different tab in the same
spreadsheet.

I am familiar with dynamic ranges,
=OFFSET(Master!$I$1,COUNTA(Master!$I:$I)-7,0,7,1)

I use them in several charts, just not sure how to transfer that same
functionality to a spread sheet.

Thanks

Jeff

--
Jeff

--

Dave Peterson