I have a "DETAIL" worksheet which tallies numbers:
(Column A) (Column E) (Excel Row #) DATE TOTAL ... 700 6/8/2015 =sum(D701:D709) 701 702 703 704 705 706 707 708 709 710 6/9/2015 =sum(D711:D719) ...
I want to retrieve the TOTAL from Column E in the Detail Worksheet from another sheet
(Column A) (Column B) DATE DETAIL TOTAL ... 6/8/2015 =sum(Details!E700) 6/9/2015 =sum(Details!E710) ...
What I would like to be able to do is to select
=sum(Details!E710) and have it autocomplete down the next cells:
=sum(Details!E720) =sum(Details!E730) =sum(Details!E740) =sum(Details!E750) ...
It's not working because the original figures are ten cells apart from each other, and I can't figure out how to autocomplete this task to retrieve them all successfully. How do I retrieve the right values from the original sheet?