request

  1. S

    Calculation help (If And)

    Hello, I am looking for some assistance with a formula to calculate product shipment performance. Cell A1 = Agreement days for all orders. Lets use 10 days Cell B1 = Customer request. They might want it sooner or maybe a delayed shipment. Cell C1 = Actual ship date. You can see that there...
  2. B

    Formula help

    Hi I have a data column that shows a series of level 1 and level 2 tags. the data presents as L1 space and then the name of the level 1 tag then a comma space then L2 space and the name of the level 2 tag. See examples below I urgently need a formula that returns the L1 tag name and a second...
  3. D

    Using COUNTIF for Dates

    Lots of threads like this, but not answer my problem. I tried to explain in a previous post, but my logic was wrong and I'm not authorized to edit my posts. My issue is similar in that I have two columns; Date of Request and Status of Request. For those requests in a PENDING status, I want to...
  4. J

    fillable form in word

    I would like to create a fillable form in word where after inputting the data and clicking on submit the file is saved in a location with the name of the file as the name which we input there and an email is sent to a group of individual for notification purpose. Eg: First Name Rohit Last...
  5. M

    Covert cells with multiple data to rows

    We use a SharePoint library for end users to submit requests for changes. Because they can submit multiple lines of changes, this produces an output file like the one below. I don't mind copying the data and pasting it to another sheet. However that can be quite time consuming when there are...
  6. T

    Copy, Paste, Replace VBA Code

    Hello guys so I have this formula on say A2. =IFERROR(IF(INDIRECT("'CAR 002'!G25")="x","Employer's Request",IF(INDIRECT("'CAR 002'!L25")="x","Contractor Request",IF(INDIRECT("'CAR 002'!R25")="x","Consultant Request"))),"") How can i copy this formula on A3 but changing CAR 002 to CAR 003 and...
  7. MrKowz

    Bug: Post titles containing a percent sign are generating an error

    Any post with a "%" in the title is generating the following error: Bad Request Your browser sent a request that this server could not understand. Browser: Google Chrome and Internet Explorer Device: Laptop (Windows 7) and Mobile (Android)
  8. S

    Conditional Formatting

    Hi all. Im looking for some help with Formulas and conditional formatting. i have 1 work book with 2 sheets. i have information in column a and b of both sheets. i need the formatting to do a few things. the idea of the sheets is for sheet 1 to have information entered into it and sheet 2...
  9. A

    VBA Request - Break External Links Leave Formulas and Values

    Hi, I am trying to modify this VBA I found on the forum that is several years old. Sub Test() Const LinkName As String = "Book1.xlsx" Dim CalcMode Dim ws As Worksheet Dim WorkRange As Range Dim Cell As Range Dim FormulaParts As Variant Dim i As Integer Dim...
  10. 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...
  11. Grizlore

    Emailing a meeting request to Outlook

    Hi I am trying to find out how to email a meeting request to Outlook from and Excel Userform. I have seen example code on how to create an email. I have seen how to add something into an Outlook calendar.... but what I need to to be able to create an email which is Outlook meeting request...

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