I know this is possible bc my intern was able to do it but now that I'm trying to replicate it....I can't seem to figure out how he did it.
Before everyone asks about changing the format, etc. it is not an option. We use a "bowler" chart which tracks the plan vs actual for key metrics...
Sorry if there is another thread about this, but I can't find any, or I don't know the right search criteria :-)
Please see below table.
Do you know a formula to calculate how many times two specific companies, has been working on the same project?
In below example the results should be...
Hello Guys. Please help me with my little Project.
I have this project where i needed to link a database(Process2.excel) to another database(Process1.excel) so that it can automatically compute the offset adjustment(CNC Machinining) based from the Part ID's data from the previous process. The...
I have quite a few years experience with VBA and have developed various dashboards and tools using APIs and web scraping etc.
I'm looking to further increase my skills and wondered if anyone had any cool project ideas. I really don't mind what it is. I'm particularly interested in getting...
Ive been having some errors with this part of my code in bold.
as i have this code run for 4 different sheets, each sheet will come back with different data, some sheets even with no data.
this code works fine on 1 sheet, and the rest keeps getting stuck at the bolded part even though...
Fluff very kindly posted the following code to enable the automation of advanced filtering from one worksheet to another in the same workbook for variable criteria without having to reinput the criteria each time. But how would this be done from another workbook? The data is in a workbook...
I created a file with VBA included. A buddy copied it to use on his network. He needed some fixes so I opened the file and the VBA developer but could not edit the code, it said that the project was locked and unviewable.
I've never encountered this before...any idea what would cause this...
As I trying to get my coding better, I've been searching for advice regarding which is a better technique. More Modules, each with a unique name referring to the (perhaps) one to five related modules, or fewer modules with more routines in each module.
I have figured out it's easier to have a...
I have an excel document that details the projects we're working on and who the PM is. plus a lot more detail about that project this is one a tab called Team POAP.
I want to create a summary overview on a different tab (called Timer Tracker) that shows the PM down column A and then in each...
Virgin poster here, rookie VBA user...please be gentle...
I have a Master workbook which automatically compiles various worksheets drawn from different Project workbooks (no code involved, just links)
Besides the linked data, I also need to copy/paste tables and graphs depending on...
All, wondering if someone can help me with a formula. I need a formula that will calculate the month when total project cost has been spent (e.g. 500 in the table below). In the table below, the correct month is 5.
Can someone help me with creating excel macro for the following.
Data will be entered in the "Main" Worksheet Table. Shown entries for a project with two units - Unit 1 and 2. this could be multiple units.
"Enter Project Name Here"
"Enter Test Date here"...
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...
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...
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?
I thought this may be easy, but I'm finding it aggravating
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
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...