approve

  1. D

    How long does it take a moderator to approve a post

    Hi all, new to this forum. I tried to make a post about 4 hours ago but it will not show up in the Excel Questions forum. How long does it usually take for a moderator to approve it. I made myself look stupid by trying to post it twice more thinking I did something wrong the first two times.
  2. X

    Only approve form if name is in a list

    Hi I have written a macro that enters the excel login user name into a locked cell and then locks the sheet from further editing. My formula is below. I am looking for a way to limit the people who can approve the form, either by checking against a predefined list or contained within the macro...
  3. J

    Formula to extract one piece of information from multiple lines of data

    Hi Excel gurus! I receive a report that has mixed data in that some users have one row of data and some have two. I'm trying to extract one piece of data from multiple lines for a user. For example - this is the "lookup" report: User ID Outcome Date Assigned 1234 COMPLETE...
  4. J

    Outlook VBA - Automatically select Approve

    Hello folks, I am hoping someone out there might be able to help with this. I get a lot of emails everyday where I need to select the Approve button. The Approve button is a link to a generic email address and includes the request ID, which is unique for every email. Is there a macro that...
  5. S

    Consolidate Sheets while Splitting Rows - Best way to achieve?

    I have two worksheets with data, Communications and Training. Each row contains two date columns, "Approve By" and "Deliver By". I have a third sheet that has an automated calendar that will take a Date, Name, and Details from the fourth sheet - Calendar Items. What I'm struggling with is how...
  6. B

    Count networkdays when value in another column changes

    Hello all - Hoping someone can assist. Considering the data below, when the Request ID changes, I would like for Excel to return the number of work days that have passed by looking at the DispositionDate column. For example; 5 work days passed while Request ID 177 was being approved. Thoughts...
  7. M

    Dynamic Range for Pivot table not working

    I created the following formula for a dynamic range and I get an error when attempting to create my pivot table =OFFSET(CURRENT!$A$1,0,0,COUNTA(CURRENT!$A:$A),COUNTA(CURRENT!$1:$1)) The error I get is as follows: This command requires at least two rows of source data. You cannot use this...
  8. F

    E-Mail macro deletes macros in workbook

    I'm sorry for the length of the post, I am trying to provide as much info as possible. I have a shared workbook form that various users fill in and then send to the appropriate managers for approvals. The workbook is basically a template, although just saved as a normal .xls workbook (sadly...
  9. B

    I know this is Mr. Excel and not Mr. Outlook but...

    I know this is Mr. Excel and not Mr. Outlook but this forum has been very helpful to me in the past and I do not know where else to go for this kind of issue. I am the team leader of my shift and I use a shared outlook calender to keep track of vacation and attendance. It is shared to everyone...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top