PPRuNe Forums

PPRuNe Forums (https://www.pprune.org/)
-   Computer/Internet Issues & Troubleshooting (https://www.pprune.org/computer-internet-issues-troubleshooting-46/)
-   -   FDTL: Excel spreadsheet question (https://www.pprune.org/computer-internet-issues-troubleshooting/401676-fdtl-excel-spreadsheet-question.html)

Vertical Freedom 11th January 2010 15:26

FDTL: Excel spreadsheet question
 
Wishing all Fling-Wing Pilots the Best year ever for 2010. I have a great Excel FDTL spreadsheet that I have been using for many years, but sadly it does not extend beyond 2009, anyone know how to extend this to 2010 & beyond, please? Or alternatively a new & simple FDTL Excel program. Many Thanks VF :)

Um... lifting... 11th January 2010 15:36

Edit > Move or Copy Sheet > Tick "Create a Copy" and "OK" > Double click the naming tab on the new sheet and entitle it whatever you wish > go to the new sheet, change the first date, manually edit the first few boxes or if you're an Excel whiz, have them come over from the last lines of the previous sheet. Any reasonably talented Excel helper-type-person can walk you through this in a couple minutes.

Commands may differ slightly depending upon your version of Excel.

Vertical Freedom 11th January 2010 17:06

hmmmm tried that, thank you but did not work?? :confused:

Keef 11th January 2010 19:15

If I knew what FDTL is, I might have a clue.

I only fly fixed-wing, but that's never interfered with pootersmiffing before.

Whirlygig 11th January 2010 19:41

Flight Duty Time Limitation - applicable to fixed wing as well :ok:

Which version of Excel are you using? Have you got to the limit of 65k rows or IZ columns? Excel 2007 has more. But otherwise I can't see why creating a new sheet and copying the existing formula across wouldn't work.

Cheers

Whirls

Vertical Freedom 12th January 2010 04:23

Hi, yes i am using Office Enterorice 2007, no have not reached those limits yet?? thanks for helping

Vertical Freedom 12th January 2010 08:05

:ok: Yay, thank you all I got it to work (finaly) :ok:


All times are GMT. The time now is 13:32.


Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.