Tuesday, March 3, 2015

yogi_Make In Row 2 Of The Sheet A Dynamic Copy Of The Last Row Of The Sheet

             Google Spreadsheet   Post  #1905
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-03-2015
question by quasimod:
Sheets Formula that copies last row to first row?
Is there a formula that just copies the last row of a Sheet to the first row (actually the second row) of that same sheet, and updates as new rows are added? 

(I'm trying to copy the latest info from "Trip Working" into the appropriate cells of "Copy of TripFormSheet", so I can print it out as a paper report).


"Copy of Trip" contains 3 Sheets, "Trip Input", "Trip Working", and "Copy of TripFormSheet".