How do you reference another sheet and drag it?

[Nishley]

Hi I'd like to reference another sheet with the = sign, then drag it down using relative reference option. There are thousands of rows. I don't want to use = for every single row. Does anybody know how to do this?

[#2]

@Nishley 

Spill it. Use a dynamic array:

[#3]

@Patrick2788 

Thanks. And thanks for leaving out the 'duh.'

[#4]

@Nishley 

No need for duhs.  It's a new feature. Spread the word!