BiancaSlate
New Member
- Joined
- Jun 18, 2014
- Messages
- 4
Excel Newbie here, and all I really want to do is get totals for how much money each person spent each month, on fuel and vehicle maintenance, and have it separated out by job paycode so that the correct departments get billed for it.
I have a workbook being used as a Vehicle Maintenance Logbook, with over twenty people, who each have their own separate tab, listing all of their vehicle-related expenses. The first page of the workbook is informational for HR, listing each person and their job paycode, and other bits of personal information I do not need to be worried about.
I've gone through the separate worksheet pages, trying to make them as similar as possible, to facilitate the use of functions throughout the workbook; however, I still cannot determine a way to get the monthly report I need, without going to each page and copying the data cell by cell, using the Consolidate Data function.
I know the individual pages are badly named for 3D use as they have spaces and special characters in them, but if I could get a way to produce the report easily, I'm certain I could talk The Powers That Be into letting me re-name them.
I need to produce a monthly report for each job paycode - there are eight. The worksheets are in alphabetical order and I am not allowed to group them by paycode for privacy's sake as well as HR likes them alphabetic - so after the Utility Vehicles, Bumblebury is first and Zathras is last (in my example).
The most people with the same paycode is eight, but none of them are close to each other, alphabetically. I've tried just biting the bullet and hand coding it myself, but I guess the worksheet names won't let me, with names like Utility #1 SR12948 and Wren, B SR12918.
Any helpful hints or suggestions would be welcome. I'm using Windows 7 and Excel 2010.
I have a workbook being used as a Vehicle Maintenance Logbook, with over twenty people, who each have their own separate tab, listing all of their vehicle-related expenses. The first page of the workbook is informational for HR, listing each person and their job paycode, and other bits of personal information I do not need to be worried about.
I've gone through the separate worksheet pages, trying to make them as similar as possible, to facilitate the use of functions throughout the workbook; however, I still cannot determine a way to get the monthly report I need, without going to each page and copying the data cell by cell, using the Consolidate Data function.
I know the individual pages are badly named for 3D use as they have spaces and special characters in them, but if I could get a way to produce the report easily, I'm certain I could talk The Powers That Be into letting me re-name them.
I need to produce a monthly report for each job paycode - there are eight. The worksheets are in alphabetical order and I am not allowed to group them by paycode for privacy's sake as well as HR likes them alphabetic - so after the Utility Vehicles, Bumblebury is first and Zathras is last (in my example).
The most people with the same paycode is eight, but none of them are close to each other, alphabetically. I've tried just biting the bullet and hand coding it myself, but I guess the worksheet names won't let me, with names like Utility #1 SR12948 and Wren, B SR12918.
Any helpful hints or suggestions would be welcome. I'm using Windows 7 and Excel 2010.
