Hi all...a newbie here.



I'm okay with many Excel functions, but I don't go too deep: Can't do macros, lookups, that sort of thing.

Here's my dilemma: Sheet-2 has a list of 10 aircraft, and the goal is to accumulate the hours-flown for each aircraft...Column A is the aircraft# (1-10), B is the aircraft name, C is the accumulated hours-flown. Keeping it simple, let's say that A1=1, B1=Cessna, and C1=26.5

Now, back to Sheet-1: Someone flew the Cessna for 2 hours...in A1 I'll enter 1 for the aircraft#, and in B1 I'll enter "2" for the hours-flown. Now Sheet-2 C1=28.5, or maybe some cell on Sheet-1, for all I care.

I can, of course, just go to Sheet 2, find the right column/cell and update manually, but this is duplicated effort that leaves way too much room for human error.

If anyone can help with this, it would be much appreciated...let me know if you want a copy of the existing spreadsheet.

Thanks,
Garry (garry@lewisaire.com)

Hi Garry,

If I'm right in understanding, you just want to enter the number of hours flown and to see the summed number of hours in sheet 1 e.g. 2+26.5 = 28.5. That's easy and I can give you that.

However, I'm assuming that you actually want this to an accumulating sheet? i.e. you want to go in next time and you would then log another 2 hours and it would then be 28.5+2=30.5? Please confirm whether you intend to use it this way as that changes the way I would approach it drastically.

Thanks,
B

So you have a sheet where all your aircrafts are registered. And another sheet, where you want to register the number of hours per flight.

As start, define the datarange in column A of aircraft list (e.g. A2:A11) as Named Range (this is needed so you can define Data Validation List for selecting aircrafts on your 1st sheet (let's refer to it as Flights);
In Flight sheet, you need a table where you register all flights for all your aircrafts - i.e. you need there a table like:
Column A - FlightDate (an optional field for you, but may be very useful), Column B - Aircraft, Column C - FlownHrs, ... ;
For datarange in column Aircraft (table fields below header) in Flights sheet you define a Data Validation List which refers to Named Range you defined based on Aircrafts in aircraft list. This allows you to select any of registered aircrafts;
Now, to register a flight, you enter a new row of data into Flights table: Optionally entering Flight date (btw, there exists an Excel shortcut to enter current date), select the aircraft from Data Validation List, and enter the Flight time;
On aircrafts Table you have a column A for aircrafts, column B for their name, and column (C) for accumulated hours. Let's assume your datarange there starts from row 2 (row 1 are table headers). Into C2 enter the formula like
, and copy the formula down. For every aircraft, the total flight hours are calculated.

As start, you can simply create an empty Flights table, and start to fill it. When the end of table will be near, you simply add new empty rows into table (my advise is, add those empty rows not below existing ones - unless you use Defined Table, but e.g. before the current last row - then there is quite a good chance, that your formulas will be updated automatically to take new rows into account).

About the bonuses the flight date will give you - with this date present, you can p.e. design reports, where flight hours for every aircraft for selected time interval (e.g. for selected year, or for selected month of certain year) are returned.

@office This thread being 18 years old, I hope the OP has solved it already.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post