Excel AutoFill Reference other sheet
I want a column to contain multiples of 9 in reference to cells on the
first page (that I've titled Log). So column will be =Log!F9 then
=Log!F18, etc. Is there a way to make this Autofill work? If I just have
F9, and F18, select and autofill, it will do the multiples of 9, but not
if I have the reference to "Log"
No comments:
Post a Comment