wbs

Hi, can someone please help with the VBA code for splitting a WBS column into the individual columns. Just need it for 4 levels and usually in excel i can just have a if statement that bases it on the number on ".". is there a cleaner way to do it. my WBS child numbers can be multiple...

As the title states, is possible to "list" all open workbooks but not include the current workbook. After searching the web this is closest the following code is pretty close to what I am looking for, except it list each individual open workbook in a msgbox one at time. Which makes sense since...

I have tried this formula a NUMBER of different ways and still not able to get the result I'm looking for. I think I've researched it so much that I'm now trying the same things repeatedly and still not getting the answer, so I'll make my first post over... I'm working with excel 2016, while...

Hello friends, I'm trying to create a sheet used for project estimation and i want it to be simple to use. I want to be able to use buttons to create/delete tasks (cost item) as well as buttons to indent/outdent a task. The later should function like MSProject works. An indented task is now...

I am moving from an Excel worksheet to a MS Project file. I have a WBS column in Excel, and I copy it over to the Project file with my other columns. I want the summary tasks and sub-tasks to be formatted via the WBS I copy over from Excel. Can someone help me with this? Thanks!

Hi, I've set up a budget for tasks in weeks. However, the cost ledger is prepared monthly and I am trying to capture my source data in weeks and arrange into budget for the month to enable analysis against WBS codes. On the attached I've used the MONTH and YEAR formula to convert my week ending...

In this thread: https://www.mrexcel.com/forum/excel-questions/1051620-running-macros-excel-2016-screen-flickering.html#post5049484 ... I was given the advice to use Application.ScreenUpdating = False on my entire code to prevent screen flashing/flickering while running the code (this issue...

Hi, I have a file that exports out of a system as text, the format of the lines are all slightly different and will show as: | PRJ 001 | -- WBS 002 | ---| WBS 003 |--||| WBS 004 |--|||--WBS 005 I would like to trim everything to the left of the first letter but I am struggling to find a way...

I have a routine that imports a Microsoft project plan. That all works perfectly. I'd like to create some VBA code that would apply the "+" and "-" to collapse and expand groups based on the WBS code. I'd like a "+" by the 1, 1.1, 1.1.1, 1.2, 1.3 and so on depending on the indent level when...

Hello friends, hope all is well! Please help me. I have 5 workbooks (WB1,WB2,WB3,WB4,WB5). Each workbook has 1 sheet. These WBs have the same order of column headers. I have a separate workbook that will have a PowerPivot. I want to see the contents of the WBs in the sourcedata (Manage...

Is it possible to have two (or more) excel workbooks linked to one powerpoint?> I currently have a financial template setup to compile data/information that is then linked do a powerpoint. This way, at each month end, you select the latest date and the most recent information is populated into...

Morning all, I have a matrix of data that I want to turn into a database type listing so I can use pivot tables on the data. By way of example, I have a table that looks something like this: <tbody> WBS ABC WBS XYZ WBS LMN GL Code XYZ $10,000 GL Code ABC $12,000 $10,000 GL Code...

I'm trying to find a formula that will help me to auto-calculate the Start Date, Due Date, and % Complete based on an existing formula for Work Breakdown Structure (WBS) in a Gantt Chart. I have a project plan/gantt chart that has three levels of detail in the WBS (1, 1.1, 1.1.1, etc.). Here's...

Good Morning All I've searched the forum using Google and found two posts associated with RACI charts (aka RAM Chart), however they don't handle my situation. I am trying to go from a Work Breakdown Structure (WBS) developed in MS Project 2010 on a Windows 7 platform to a RAM Chart in Excel...

Let's call the numbering system in column 1 a work breakdown structure (WBS) or hierarchical taxonomy. There is no fixed number of elements below a top level, There is no fixed number of sub-indents. Therefore, the maximum length of 'Number' field is variable and unknown. I am attempting...