Copy formula qucikly

[dawngrogan2207]

How to copy a formula - first one is =sheet1!k8 next one is =sheet1!T8 next one is =sheet1!ac8 and next one is =sheet1!al8 and so on, I have a 100 to copy down a column in sheet 2 is there a quick way to copy the formula rather than doing it individually?

 

[Fluff]

How about

=INDEX(sheet1!K8:DZ8,SEQUENCE(100,,,9))

 

[dawngrogan2207]

Thanks I will try and let you know if it works

 

[Fluff]

Ok

 

[dawngrogan2207]

Thanks worked perfectly

 

[Fluff]

You're welcome & thanks for the feedback.