project

I may have seriously gotten in over my head with a project when it's been a while since I coded. Basically I have a workbook that has a sheet for each month (12) January 2019 to December 2019, I need certain information (Column A B C D E F G H I) to compile to one main sheet in the next...

Morning all I have a worksheet "Project Summary" Columns A to L which is a summary of another worksheet "Project Master" Columns A to BW. ONce the data is pulled through from "Project Master" I am using the following code to sort the "Project Summary" sheet: Sub SortMultipleColumns() With...

Hi there, First my apologies if there is an answer to this already in the forum, but the amount of info is a little overwhelming and I'm taking the quick route; hope you don't mind. There is a register related to my work that I have to check every week to see whether there are new entries or if...

how can i list all the subs in my project into a listbox and then run the subs from the listbox?

Hi Excel Masters! I have a situation here. I've created a search function where I can search a data set by typing in a client name (or partial name), and my table will return all entries with at least a partial match. I.e. search "Ohio" and it returns Ohio State, Ohio State University, Ohio...

Hi in Column A, I have a mixture of 7 and 10 character long project numbers. In Column B I want to reference all project numbers to a uniform 10 character format. With the 7 characters ones I want to add “/04” to them. Can this be achieved with a LEFT and IF formula? Thanks

Firstly, apologies for no dropbox/image - both methods are banned on my company server. Criteria - Columns B4:B11 with Project 1, Project 2, Project 3...Project 8 - (Actuals) Columns C3:N3 (Apr 20 through to Mar 21) - (Budget) Columns O3:Z3 (Apr 20 through to Mar 21) - Current month (Jul 20) =...

Afternoon all I am using the code below to populate a Userform from data held on "Project Master" Worksheet. I am trying to add a command button to transition to previous and next rows, but for some reason the code i tried either jumped me to the header row (row 1) of the "Project Master"...

I’m self taught so the macros I write are quite simple and sometimes long winded. I usually succeed in my endeavours but I’m completely stuck on this one as I don’t know quite how to start. Sorry if this question has been asked many times before. I’ve looked but can’t find an answer I...

Basically, you can see clients on the left and then different stages of the project next to it. These dates are manually entered. The "(IR)" is basically our internal review and has to get priority if it's in the same week as the same stage without "(IR)" Because it has to get priority I did a...

Hi expert, I am using multiple sheet pivot table with <colgroup><col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3490;"><colgroup><col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 2932;"><colgroup><col width="95"...

Good Day :) I have to calculate the per day amount for a project and put it in a report showing it on an annual basis. My issue comes if the project starts mid of the month, i need a formula to determine the date from project start to year end and calculate per day rate. Eg: Project Start...

Hi all, I have two tables. 1 - contains project profitability data. It contains the period end date and the project number and name with the relevant data against (many many rows) The above three criteria will duplicate in the list as a new months information is pasted into the rawdata 2 -...

Hi, I have a file which has the following information in Column A : <tbody> Project: ABC 1 34 45 Total Project: XYZ 3 56 Total I would like to all rows which do not contain "Project:" or "Total" to be deleted IN this case, the final output should look like this : Project :ABC Total...

Hi, I'm completely lost where to start with this one. I have a table of data (Column A = Project Number, B = Name, C = Address, etc) then at the end of the table in Column O, i have "Make folders?". I am trying to write a piece of code that when the user marks that cell with "yes", a command...

Hi! I'm not sure how to phrase my question which makes hard to search for an answer....Can I sort by a grouping under a heading? I have a sheet that I want to filter (by person), but I want the subheadings (Project name) to be included with the filtering. I can only explain by pictures...

I need help filtering on multiple criteria. Consider the sample data below that provides a greatly simplified data set. I need to show all data for the current date and any data from previous dates with a status of "Complete Pending Verification. I am not sure if it will matter, this table...

I'd like to have the word Project appear in cell E2 on the first Monday of each month. Any ideas on how to do that?

Good morning all. As always, thanks in advance for your time... I need to capture project status for a list of projects over time and keep historical record of those statuses. I currently have a data connection from a sharepoint listthat brings in a list of projects and their statuses (along...

I would like to ask any possible Transpose shortcut on my recent project, which wish someone here guide how to Transpose as attached image. Appreciate someone help. thanks