I have a "DETAIL" worksheet which tallies numbers:
DETAIL WORKSHEET
(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!E700)
and =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?