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 table in the same
spreadsheet.

I don't want a sum of the range or average or anything. I just want a range
I can put in a table that is updated daily when I update the oringinal table.

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 table.

--
Jeff