project

Hi all, I received help on this problem for a previous project from this forum, for which I was very grateful. The code I was given is as follows: Private Sub Workbook_Open() Dim ws As Worksheet For Each ws In Sheets ws.Protect Password:="dataplan", UserInterFaceOnly:=True...

I'm using the following macro to unlock my VBA projects when the workbook is opened. However if I already have another vba project unlocked, this macro will sometimes just place the password inside module and do nothing. Is there a way to designate specifically which project should be...

Hello I am a VBA novice but have been having a crack at the following problem but I need more expert input and assistance. The problem is to extract information from control content field into tables and "related" and copying the information to a single row in excecl. I am having difficulty...

I have a project plan that works fine. I'd like to add a column for dependency and the date would be updated based on the finish date of the row id that is entered. Any suggestions on if this is possible?

Hi Everyone, I will be great-full if someone can help me with the formula or macro on this. We have tasks assigned to each department with the due date. The tasks have been distributed in the order that they need to be completed. This is done so that each department completes the tasks in...

Hi I have a huge project sheet with dozens of projects along with tasks and the associated contacts. My source list is set up like this: <tbody> Role Proj A Proj B Proj C PM Bob Sue Dan BA Phil Mike Matt SME Ryan Jack Larry </tbody> Each tab a is project with a all of...

Hi Guys I am creating a master spreadsheet and need some formula help. I am trying to pull through names of employees based on if they have a value against a project For example A,B,C are three projects on three seperate tabs. Person D,E,F are employees. Person D and F have logged time...

Morning all I have an excel workbook I am using as a database with 2 worksheets "Project Master" with 72 Columns of data and "Project Summary" with 8 Columns of selected data from "Project Master". I also have a Userform "frmViewData" which when open is populated by selecting a Project from a...

Hi everyone! I know the title is very generic but what I'm trying to do is hard to explain in a short sentence! :) I'm working with multiple workbooks that I'm trying to combine into one workbook with multiple sheets for 2 reasons: 1-it will eliminate some double entry the client is doing...

Hello, I am new to Pivot Tables, so my question could be very stupid... I have a set of data which shows employees labor forecasts for the upcoming year. The data is divided as such: Employee Name; Project Code; [12 Monthly forecast columns (apr-mar)] Each Employee can be assigned to multiple...

Hi, Only when sorting numbers in ascending or descending order all row information get's messed up and disconnected from where it actually belongs. Due to this wrong data is presented under all project numbers. When clearing the filter, it does not return to the correct project number. I have...

I have an intermittent problem going on - we have several files with macros that are saved with the worksheets that worked perfectly for over a year and then I got a new computer. The IT guys swear the version, Excel 2013, is the same but now I am getting intermittently an error that it cannot...

Hi I have 2 workbooks, one with 25 sheets each relevant to a particular project and a second containing recently received invoices. Certain parts of the information of these invoices are to be copied to the relevant project sheet. Each project sheet has a number of nominal codes (there are...

This may be a basic question for many here so apologies. I'm working with a Project Tracker within Excel for the first time. I have the following catagories Status Assigned to Categories Percent complete I need to add more titles within the Category bucket I've looked and researched but...

Hello, I hope you can help - my VBA skills are extremely lacking, but I don't think what I'm trying to achieve is actually too difficult. I'm trying to copy rows from multiple sheets to one summary sheet based on whether the row shows 'completed' in a certain cell or not. I have a workbook...

Good day. I'm setting up a worksheet that will track a contractor's daily labor, times it by their hourly rate, and provide a total cost for each week worked. That part works fine. The weekly costs are then associated with a project(or cost center). I have added an extra column to show which...

Hi Folks, Periodically, when opening & launching my project in Excel, I get an Automation error Exception occurred nastygram, which then closes (crashes) Excel. It doesn't always happen, whether I've changed anything or not. The only way I've noticed that avoids it (after repeated attempts...

Hello In Column B under project I can only have one project listed for the types of Technology and Request types(C,D) I will have this format throughout the worksheet. When I do pivot table I am have issues seeing the results for Project. I suspect it is because everything under AGR-20108...

Hi, I have created a template for providing monthly reports on financial figures. I paste 1x row per project in sheet(1), then I have 7x sheets with the exact information (they are all linked). To those 7x sheets I have 7 different pivot tables. When I update sheet(1) with new information and...

Hi Expert, I am new in a Excel. I have created a trainee project for my learning and which is attaching hear. In my project all are okey, but i don't want to show any work sheet in this excel, is it possible? if possible please instruct how can i do this. please note that UserForm1 and...