Offset help!

[cegarbage]

On cell A8 of one tab, I am running the following formula to extract data from another tab
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
=OFFSET(TECHDEVCOR!$B$8,0,0)<o></o>
<o> </o>
On cell A9, I have the following formula<o></o>
<o> </o>
=OFFSET(TECHDEVCOR!$B$8,0,1)<o></o>
<o> </o>
In subsequent cells, I’m looking to add columns in the same pattern as above. How can I do this dynamically? When I drag the formula down the column, the columns aren’t increasing. There has to be a way to automate this!<o></o>

 

[VoG]

Maybe in A8 copied down

=OFFSET(TECHDEVCOR!$B$8,0,COLUMN()-8)

 

[cegarbage]

that gives a reference error...

 

[Excelestial]

=OFFSET(TECHDEVCOR!$B$8,0,0,COUNTIF(other tab A:A,">"""),1)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Countif should count how many rows are not blank in column A (hypothetically). this means there can be no blank rows between the start and end of the array A:A.