I have a spreadsheet in which on Sheet 4, I want cell C3 = Sheet2!D5, C4 = Sheet2!F5, C5 = Sheet2!H5 and so forth all the way down to C84 = Sheet2!FJ5.
However when I use the Fill Handle to drag down and calculate the rest of the values, it does not recognise the pattern.
Is there a function I can input which will allow me to do this?
Thanks.
Bookmarks