resource

Hello and thank you for any attention my post may receive. Is it possible to update a MS Project's resource list from an excel file via vba?

Very new to VBA but understanding its potential, I feel there is a way to avoid using track changes option and get more by using appropriate VBA. I am working on a resource forecasting spreadsheet that has columns dedicated to each quarter for year 2018 and subsequent years. Multiple users will...

Is this resource only available online now?

I have a table "Resource_Assignments" that list resources and projects they are working on. Resources can have multiple project assignments (one assignment per row), and there is a potential for overlapping dates. Each project has a start date and end date. I am able to calculate the number...

Hello, I am looking for some assistance in writing a macro to transpose timespread data that is coming out of a program that I use. I need to be able to make a calculation on the data, then put it back into a pivot table to spread it again by period. I only need help getting the data from...

So Friends, I need help regarding below table. I needs "Hours" for respective Resource, basis the current day. Please note the range of dates extends beyond below table. I tried doing it by IF function, but it is too complicated for me after 1st/2nd Logic for me. <tbody> 27-Nov-17...

Hi All, I have created a dummy sheet and uploaded in below mentioned link with desired output which I needed. https://1drv.ms/x/s!Ap80Ku6M2Tw5gSjnz_4XxSm4Rg5R Logic : - 1) IF RESOURCE STATUS or ASSIGNMENT STATUS is LEFT PROJECT or OLD-INACTIVE and Hourly rate is 0 then output should be...

HI I have 2 sets of data I2:I13 and J2:J13 What I want to do is compare the cells and if the cell in I2 is > J2 then a message. This would be relative ie would compare all cells - I3>J3 ect This is what I have Private Sub Worksheet_Change(ByVal Target As Range) If Range("I2") >...

Hello, I am attempting to create a break out crafting/costing system for an online game. The game market system is all posted on an online website so I have been using Excel Power Query to gather the information into a list. The issue I have run into is that the information I've gather has been...

I'm tired of trying to go through brick walls. I'm willing to try going around. I've been using Excel VBA to automate Internet explorer for several years now. All of my knowledge has come from online examples and the school of hard knocks. On top of that it's 3-6 months between coding...

I have a software team that is being assigned too many tasks/projects per week, but we're having a tough time communicating this to upper management so we can help throttle the workload demands. I'd like to do a utilization chart, but had some questions: To set up, we're only measuring 4...

<tbody> I work with a resourcing ledger which is also used for other financial purposes. As a result of the financial phases each resource in the file is split over 4-5 rows. What I would like to do is create a macro which finds their start date and corresponding end date on...

I'm putting together a custom resource sheet. I want to neatly list the bookings for a particular person on a particular date. I am inserting the correct amount on new rows for a resource, then placing the name of the project they are working on in the cell (for a given date). The problem is...

Hi folks, long time lurker and this forum has been a great help, but now I'm stuck, I'm signed up and hoping you can help with what should (in my head) be as easy as pie, but I'm stumped :( I have a basic 'resource required' table that tells me what various resource I need and for how long...