resource plan

  1. C

    Communicating cells between worksheets - available resources problem

    Hello, I have a worksheet with a lot of information, and I want to make another one in the same file with some concise information, but when data is changed in the first worksheet to automatically change in the second one. I found the following sollution: copy the respective rows and paste...
  2. E

    Room Availability Testing - Help please

    My self and a colleague schedule a training plan for our business on a national scale. We are trying to streamline the processes by building the facility to check the availability of rooms based on a date variable we enter. Our issues is that a training room will be used for multiple courses at...
  3. A

    Resource Planning / Resource Allocation

    Hi, I am developing a template for planning resources based on their availability and task scheduled. My first input will be resource availability calender, which shows available hour of each resource on a given day. Second input will be start and finish date of task with budgeted hour...
  4. M

    A macro to auto generate rows based on date range

    Hi, I have tried to look around different forums in order to find some help with my problem, but I have not had any luck, so now I hope one of you might be able to help me out. I am working on generating an overview of my departments capacity in mandays pr. month for a Resource Management...
  5. R

    VBA userform data transposition: HELP!

    Hi there, I am stuck developing a VBA userform thats supposed to serve a dual purpose, depending on the information entered: 1) update an employee resource list with monthly data on '% of time logged' per project 2) add new entries for employees who are either new, or have just begun working on...
  6. A

    Creating the ultimate Excel sheet - module, task, resource, hourly cost, time, allocation - weekly, monthly reports

    Hi friends, I have created a sheet, where I have the following: Module/Project Task Time taken by developer 1 Time taken by developer 2 Time taken by developer 3 Time taken by developer 4 Time taken by developer 5 Developers are segregated by offices, so there are 2 types right now, can be...
  7. B

    Conditional formatting with Nested If Statement utilising Dates

    Hi All I am trying to produce a Resource plan which shows projects in Column A, then has 5 Stages for each project which contain a Project start date then at lest 3 items of data (Stage Lead (Name), Stage Finish Date, and Stage Resource). I need to create something akin to a horizontal stacked...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top