Forum

I like Sunny's elegant solution. As a challenge to myself, I thought I would try to find an even shorter formula for O18 et seq. How about "=--(K18...

Would it be possible to manually enter the name of the current other file when the new sheet is created? If so and let's say the file name is put i...

An alternative is to create a new data column to calculate any excess hours. I used Column O with the formula "=IF(K18>J18,K18-J18,0)" copied down....

If you use Shift+Ctrl+down+ in column B then cursor left into Column A and up 1, Shift+end+up and Ctrl+D that should work (and is actually a lot quick...