Formula won't repeat

[jasonstilson]

I am struggling with finding a way for Excel to recognize a formula that I need repeated over a large worksheet. The formula is pulling from a different sheet. You can see the first formula is "=IF(ISBLANK('Tree Fill Sheet'!B19),0,(('Tree Fill Sheet'!B5)-('Tree Fill Sheet'!B19)))" In the next cell (C4), I need it to pull the information from the Tree Fill Sheet worksheet, but use the information from 2 columns to the right.so from B to D. "=IF(ISBLANK('Tree Fill Sheet'!D19),0,(('Tree Fill Sheet'!D5)-('Tree Fill Sheet'!D19)))" This will go all the way up to column ADM and I just don't have the time (or patience) to manually change all the column letters to match up. Thank you for any help you can offer.

 

[Jeffrey Mahoney]

I don't know how many columns you have in your table, but this should be quick enough to manage.

Temporarily insert a column between each existing column
Copy your formula over
Remove the extra inserted columns

 

[StephenCrump]

@jasonstilson, welcome to the Forum!

You could populate the row with one formula: =LET(a,'Tree fill Sheet'!B19:ADM19,FILTER(IF(ISBLANK(a),0,(('Tree fill Sheet'!B5:ADM5)-(a))),ISODD(SEQUENCE(,COLUMNS(a)))))

This assumes you want the last column, OG, to refer to column ADL in 'Tree Fill Sheet'