project

  1. S

    Next and Previous

    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"...
  2. P

    vba to run through sorted list and copy rows in each sorted group into a new tab

    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...
  3. M

    Maybe LOOKUP isn't the best function?

    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...
  4. S

    Multiple Sheet pivot table

    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"...
  5. R

    Distribute Project Value over entire project life

    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...
  6. S

    Related tables - two tables that won't relate

    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 -...
  7. G

    VBA delete rows which contains certain string

    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...
  8. B

    VBA to create folder if a cell value = yes in background

    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...
  9. R

    No idea how to title...Sorting in Excel to include group header?

    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...
  10. D

    Filter data on multiple criteria

    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...
  11. H

    Alert - First Monday of the Month

    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?
  12. J

    Tracking historical values: Index/Match using VBA?

    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...
  13. L

    Excel Transpose (T) From Column to Row specific position.

    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
  14. W

    running macros in locked sheets

    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...
  15. M

    SendKeys to unlock a VBA Project placing password inside an already unlocked project module

    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...
  16. S

    VBA code to transfer data from word to excel.

    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...
  17. T

    Project Plan Dependencies Formula

    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?
  18. B

    Adjust holiday (Xmas) break in between the project.

    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...
  19. M

    Index and Match values in a cell seperated by commas

    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...
  20. A

    generating named data based on values

    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...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top