Dynamically Shifting Ranges

R

RSquid

I use charts to display 21-periods of data. Every period new data is
entered, and I have to mannually change the range of values for each series
to a new 21-row range. From last period's range of "Sheet!L50:L70" to the
new period's range of "Sheet!L51:L71" for example.

I'm not clear about how to name and define a range using OFFSET where the
reference cell is 21 rows above the last cell in my vector column that has a
value (rather than the formula). Can anyone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart SERIES OFFSET 5
Pasting a cell into bookmarked table from excel vba 1
Copying Named Ranges in Chart Series 1
VBA Coding Help for Beginner 0
Modify working code to expand the output. 5
Paste a range and shifting away existing data 1
Want code to copy to ABOVE row 22 column A on sheet 1 10
Excel VBA setting Ranges 3

Top