Ah, you cannot use full columns with SP, it must be a specific range. I
don't mean filled cells, I mean defined range. It doesn't have to be the
same rows/columns, but they do have to have the same number of rows/columns.
So you should define TDate as 'trainer data'!$E1:$E1000 as an example, or
maybe dynamic

OFFSET('trainer data'!$E$1,,,COUNTA('trainer data'!$E:$E),1)

danger with the latter is ensuring that TDate and TQ7 are the same size, so
maybe use this for TQ7

OFFSET('trainer data'!$U$1,,,COUNTA('trainer data'!$E:$E),1)

this will force them to keep synchronised in size

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"javamom" wrote in message
oups.com...
This is probably a stupid question, but by "same size" do you mean
defined range or number of filled cells?

TDate range is: 'trainer data'!$E:$E
TQ7 range is: 'trainer data'!$U:$U

There will be some rows with blank cells in TQ7 but data in TDate. Does
that make sense?

Thanks! Trish