dynamic range and offset

hello,

is it possible to make a dynamic range (myRange), but so, that in excel, when I move the formula to the right, myRange take range which are in other column.

I defined myRange as =OFFSET(Table!$A$1,0,0,COUNTA(Table!$A:$A),1)

I want some formula in E1= which takes data from B:B (but only the numbers, not empty cells), in F1=data from C:C.

I think upload is the best way to see what I want, because I little confuse with this range, define name and...

thanks in advace!!

because that's only a part of formula. I will do variations on MyRange.