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