| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Support a task in excel
So I have a table list of employee IDs, along with the mutiple project
IDs and the hours against each project they have worked on. I want to pull out the list of employee IDs with the project ID and hours to which they have billed the maximum hours. Can anyone help with a macro for this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to Support a task in excel
If I understand correctly what you want, a Pivot Table is what you
need. HTH, JP On Mar 25, 6:49*am, VM wrote: So I have a table list of employee IDs, along with the mutiple project IDs and the hours against each project they have worked on. I want to pull out the list of employee IDs with the project ID and hours to which they have billed the maximum hours. Can anyone help with a macro for this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to Support a task in excel
On Mar 25, 4:38*pm, JP wrote:
If I understand correctly what you want, a Pivot Table is what you need. HTH, JP On Mar 25, 6:49*am, VM wrote: So I have a table list of employee IDs, along with the mutiple project IDs and the hours against each project they have worked on. I want to pull out the list of employee IDs with the project ID and hours to which they have billed the maximum hours. Can anyone help with a macro for this?- Hide quoted text - - Show quoted text - I have got this list only through a pivot. I now need a macro to map the project numbers with maximum hours to the employee code. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a complex task that I think could be easy with a macro | Excel Discussion (Misc queries) | |||
| How to create a macro which performs a copy-and-paste task every 5mins after data is refreshed from web page? | Excel Worksheet Functions | |||
| Event macro for a task | Excel Discussion (Misc queries) | |||
| macro to automise the task | Excel Discussion (Misc queries) | |||
| Start Macro Daily task | Excel Discussion (Misc queries) | |||
Linear Mode
