project

I have some very simple data and I have created no measures whatsoever. I am working with 2 tables. One called project table, one called budget table. When we first started we dummied in a few projects and they were never removed from the project or budget table. I filtered them out in my...

Hi all, Wondering if you could help me on this as I'm really not sure where to go. I am trying to copy data from a Sheet (A Project Charter) into a longform sheet that can then be used to update a tracker. The cells the Macro will be copying from will always be consistent however the Title of...

Hi All, Earlier I noticed that a file I opened had the words "Flexform" after it in the banner heading. Then i noticed all my files now have that however in project explorer it does now show this. Have googled and cant seem to find any answers, any one any ideas on what this is?

Hello All, I thought this may be easy, but I'm finding it aggravating <tbody> Project Name Start Finish Project 1 11/16/19 3/15/20 Project 2 6/12/2019 1/14/2020 </tbody> I want to make a horizontal bar chart with a series name of the projects...

I have a table which includes Column 1: Client Name Column 2: Project date (Must be last day of month) The unique ID is a combination of column A and Column B. So, there may be multiple instances of the same client with different project dates. I want to create a query that looks at the...

I am looking for a formula that evaluates start month for Project 1, determines it starts in November, determines number of months to complete and calculates number of transactions per month based off of those cells. Any help is much appreciated

Hello everyone! I have a "problem" in a spreadsheet that I believe through VBA I could solve. But I never programmed in VBA, so I have no idea where to start. I have a table with the following information: Project Name, Type, Stage, Value, Adjusted Value. The adjusted value depends on the...

I have rummaged through posts but cannot get any formulas to work I have a project table that has Project ID's (only one occurrence of each ID) then I have a schedule table that has the same project id's but multiple occurrences for each task that a project has. Each task has what is called a...

Hey Guys, I have a set of data with data and projects, in the format below: [Row 4, starting column F] Jan Feb Mar etc. [Column B, starting row 6] Project A, Project B I'm trying to sum all the forecast for for a project, based on the previous month's forecast - so i can compare with what's...

I have a simple Pivot: Jan Feb Employee 1 100 100 Project 1 60 70 Project 2 40 30 Employee 2 90 100 Project 5 90 10 Project 8 0 90 Where employees are assigned a % of their time each month to a...

Hey all, I am cracking my head without finding a logical solution for this problem. This is a small picture of my database (on the left) and I created a pivot table (on the right) to summarize this information. I would like excel to get the lowest number from the column G (date) and insert it...

Excel Champs, Looking for creative solves for the below problem. I have a project sheet that looks something likes below in a table. I need a button function that can transfer in a separate sheet all the values in that row for that project transposed in a column. Master file (Sheet 1)...

I made a careless mistake and left the 'Lock project for viewing' box unchecked and sent out copies of one of my models. A project password already exists. I had just unchecked the 'Lock' box for my convenience while I did some annual updates, but then forgot to check it again before sending...

Hi, I believe (but am not sure) that there is a problem with the compatability of the 64 bit vs. 32 bit settings. I am trying to run a macro and am getting the error "Cannot find library" ... then I am prompted to choose the "references - VBA project". How do I fix this? I don't care if the...

Hello, First, I cannot use VBA for this; I need the spreadsheet to function within a sharepoint environment that doesn’t accept macro enabled worksheets. I am also very new to excel, but trying to progress rapidly. I am trying to create a single sheet within my dataset to return individual...

can some one help me with this?

Hello, I have a workbook with 25 sheets (tabs), each representing a different project with data reporting the number of people reached by that project for a range of different activities. Not all projects did all activities. I have a consolidated sheet in which I need to count the total number...

Does anyone have a string of code to highlight late tasks in MS Project?

Hi, Newbie tothe forum and basic Excel user. From a text cell (Column A) I am struggling to extract the Cost Centre(Column B) and report the Project Name (Column C). In the table below, I need to see if the values in column B "CostCentre" exist in any part of the cells in column A "Cost...

This is my formula that returns the 1st value but I need to return the data from the 2nd and so on. My project is to pull data to populate invoices based on the invoice number. =VLOOKUP(value(rngInvoice),Received_Process, 2,false)