approve

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.

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

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

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

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

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

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

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

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