User Profile
HenrikKruse
Copper Contributor
Joined Sep 21, 2021
User Widgets
Recent Discussions
How to bottom and second to bottom automatic send to overview?
I am using a spreadsheet to calculate my electricity consumption and a price every quarter. Once a quarter I have to make a report. I would like it to generate the report automatic. We are sharing the electricity with someone else so there is a main measurement box and a secondary measurement box. Therefor the need for a report. Sorry for the Danish languages in the sheet. Colum 1 is date. Colum 2 is where I put in information from main box. Colum 3 calculates consumption on main box. Colum 4 is where I put in information from secondary box. Colum 5 calculates consumption from secondary box. The rest of the column makes different calculations. Colum 7 is where I put in the price from last quarter. The box in the top is what I hope can become the report. What I am looking for is a way for the report box to automatic take either input from the last filled cell or second last fill cell. I have tried to explain it in the picture.
