ATW Alex 101
Established Member
Hi guys,
I have been working on an excel spreadsheet that I will use to record my rail mileage and haulages etc. It will also include statistics and had the ability to record all loco haulages, aircraft haulages and log railtours.
It's nearing completion but I have stumbled across a problem. If somebody would be able to help me that would be great. It can be accessed in the attachment below.
If you open it up and go into the sheet named 'Loco_haulage', I want to make it so that if I enter 'LOCO' into the TOPS range in the sheet titled, 'Railmiles_log', that it will enter all the relevant data (from, to, headcode etc.) into the relevant cells. I want to make it so that however far down in the list in the 'railmiles_log' that 'LOCO' appears, the relevant data will appear in the next available row in the 'Loco_haulage'. I have tried using =IF, but if say I enter 'LOCO' in the 18th row down on the TOPS column on the 'Railmiles_log', the data will appear on the 18th row in the 'Loco_haulage' sheet, rather than the first which is what I want it to do. Then for the next 'LOCO' entry, make the data appear in the next row down. I have done =IF in the first row of 'Loco_haulage' to show what I am trying to do.
Any help or relevant formulae will be much appreciated. I know this may be a little complicated as well and apologize for that. Any questions, just ask.
Cheers in advance.
I have been working on an excel spreadsheet that I will use to record my rail mileage and haulages etc. It will also include statistics and had the ability to record all loco haulages, aircraft haulages and log railtours.
It's nearing completion but I have stumbled across a problem. If somebody would be able to help me that would be great. It can be accessed in the attachment below.
If you open it up and go into the sheet named 'Loco_haulage', I want to make it so that if I enter 'LOCO' into the TOPS range in the sheet titled, 'Railmiles_log', that it will enter all the relevant data (from, to, headcode etc.) into the relevant cells. I want to make it so that however far down in the list in the 'railmiles_log' that 'LOCO' appears, the relevant data will appear in the next available row in the 'Loco_haulage'. I have tried using =IF, but if say I enter 'LOCO' in the 18th row down on the TOPS column on the 'Railmiles_log', the data will appear on the 18th row in the 'Loco_haulage' sheet, rather than the first which is what I want it to do. Then for the next 'LOCO' entry, make the data appear in the next row down. I have done =IF in the first row of 'Loco_haulage' to show what I am trying to do.
Any help or relevant formulae will be much appreciated. I know this may be a little complicated as well and apologize for that. Any questions, just ask.
Cheers in advance.