Dynamic Range for Dummy

[j.lancaster1]

Hello,

I'm trying to use dynamic range & offsets to accomplish a task, but I am simply unable to wrap my mind around how what I am learning applies to what I need to do.
What I am needing is very simple.

I have two line graphs on a spreadsheet. One needs to pull data from ONLY T33 to the last <>"" in column T. The other needs to pull data from ONLY AB33 to the last <>"" in Column AB. The columns will grow and shrink constantly. I've done plenty of research on it, but they all deal with pulling from multiple data points for the graph, rather than just one.

Any help would be greatly appreciated.

[royUK]

Are you asking how to create two Dynamic Named Ranges?

In the Name manager click New a in the refers to box type this formula

=Sheet1!$T$33:OFFSET(Sheet1!$T$33,COUNTA(Sheet1!$T$33:$T$65536)-1,0)

Give it a name like T_Col

Do the same for AB