Excel will not autofill horizontally (using an absolute reference for a column on a dif sheet)
Hey guys, So i've been trying to figure this out for awhile now. I am trying to drag my excel formula to the right. My formula is =+'Hard cost Schd'!$E4*.86. When I drag it horizontally, it simply uses the 3 cells that I highlight, $E4, $E5, and $E6 and then copies those to the right. It will not continue my formula to $E7, $E8, etc. Automatic calculations is on AND it actually works correctly if I go vertically.. it just won't go horizontally. What am I missing?