approval

  1. A

    Combine Several Rows into one row given the data in the first column

    Hi all, I've been working on trying to set up a spreadsheet that others will be able to easily use. I've created a spreadsheet that automatically pulls the data from another worksheet but I can't figure out how to have the different column rows to combine. <tbody> Name Segment Code Date...
  2. L

    Approve message box but by the approver

    Hello All, Thank for for helping all those who are in need! I created a macro where it looks at the all required fields and then emails to approver. I have the same command button to trigger email function from requester to approver to final user. My issue is I need approved message box only to...
  3. M

    OR statement producing N/A

    Hi, I am expecting the result to produce "NO APPROVAL REQUIRED", but it is coming up with N/A. is there something wrong with the formula? the VLOOKUP result of F16 does match Q4 =IF(OR(VLOOKUP(D16,'Approver Data'!O:R,4,0)=Q4,VLOOKUP(F16,'Approver Data'!C:F,4,0)=Q4),"NO APPROVAL REQUIRED","")...
  4. M

    VAR inside CALCULATE?

    Hopefully others have encountered this situation. There's a lot I need to wrap my head around in DAX and the order that calculations happen is one of them. I'm not sure whether the following measure is doing what I think it's doing without having to create multiple intermediate helper columns...
  5. D

    Can this simple VBA code be speeded up?

    Please can someone help me improve my VBA code below? I'm teaching myself VBA and I've written a macro that works but I want to learn how to improve the code so the macro runs quicker. One part of the code that is slow is a creation of a temporary list that needs to be created on a temporary...
  6. L

    MID Function

    HI! I am fairly familiar with excel but I am really having a problem with the calculations below. The Approval History is formatted as General, the Closed as Custom but no matter what I do with formatting it won't fix the error. One thing that did work is adding the text, even just the " -...
  7. O

    Don't know how to start

    Hi everyone, i have to run a weekly report with diffrent cases. Each case has an approval path and must be approved by 6 persons. I have to find all the cases which have John Doe in the approval path, either is he the first approver or the last, this does not matter. If John Doe is in the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top