Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kei
 
Posts: n/a
Default How do I get Excel to automatically calculate salaries actually received in financial year?

The following data as an example (excluding the desired result column)
comes from an Access database. I need for excel to calculate what
employees actually salary recieved during the financial year of April
1 to 31 March.

What I want is to be able to get a user to click a button on Access
which will take them to a pivot table which displays what employees
actually received each financial year. This pivot table will be linked
to a (hidden) excel sheet where the figure has already been calculated.
As it will be a hidden sheet, I need for excel to do this
automatically but I can't figure out how to do get this figure without
manually manipulating the excel sheet cells.

I also have two things that need to be looked into ... How do we
calculate a total figure if someone received numerous salary increases
in the same financial year (see Steve Bilington 1998/1999). Also, what
do we do if there has been no salary increase one year (see Steve
Billington is missing a figure for the 2002/2003 financial year as he
received no increase that financial year. I need for excel to
recognise this but calculate a figure for that missing financial year
as I still need it to appear in the pivot table.

I dunno what to do!!!! HELP!!!!!!!!!!!! K/

FirstName LastName Salary£ FinYear Date Inc DESIRED RESULT
Steve Billington 75000 1998/1999 1-Apr-98 0
Steve Billington 100000 1998/1999 1-Jun-98 0
Steve Billington 130000 1998/1999 1-Oct-98 Sum of £ received in
1998/1999 fin yr
Steve Billington 132500 1999/2000 1-Oct-99 £ received in fin year
Steve Billington 136000 2000/2001 1-Oct-00 £ received in fin year
Steve Billington 151000 2001/2002 1-Oct-01 £ received in fin year
Steve Billington 160000 2003/2004 1-Oct-03 £ received in fin year &
figure for 02/33
Steve Billington 165000 2004/2005 1-Oct-04 £ received in fin year
Steve Billington 175000 2005/2006 1-Oct-05 £ received in fin year
Bob Anderson 70000 2005/2006 1-Apr-05 £ received in fin year
David Downes 100000 2002/2003 1-Oct-02 £ received in fin year
David Downes 114500 2003/2004 1-Oct-03 £ received in fin year
David Downes 127500 2004/2005 1-Oct-04 £ received in fin year

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to calculate integrals with Excel? Francesco Excel Worksheet Functions 6 April 2nd 23 08:56 PM
How do I automatically open linked documents in Excel? DroKoz New Users to Excel 3 June 28th 05 03:25 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
PivotTables in Excel 2004 calculate incorrect standard deviations lvphj Excel Worksheet Functions 0 May 12th 05 05:30 PM
How do I automatically send daily email of updated Excel workbook. How to automate emails with excel file. Excel Discussion (Misc queries) 1 May 9th 05 08:55 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"