I'm trying to use the fill handle to sequentially copy a formula down a column with part of the formula increasing by a value of 6 for each row. Formula: =('Workbook2.csv''!$E$1) The next cell will be Formula: =('Workbook2.csv''!$E$7) Then 13, 19, 25 etc. I filled in the first two rows in the column with the above and tried using the fill handle but it gives an error stating that a trend could not be determined or it just goes 1,7,1,7,1,7,1,7,etc. Am I missing something or is what i'm trying to do not possible?
Solved by G. H. in 29 mins