signed

  1. W

    VBA split string and add to HTML body with formatting

    Hi all, I am trying to separate string from a cell based on character present and add it after to HTML body. Sample text (all in one cell): <tbody> Need to separate it by ";" and add it to HTML body for better look, like this: Think this is somewhat common problem, but can not find a...
  2. I

    Could you check & advise on my code please

    Afternoon, I have the code below but stuck with the red section. I have a drop down list in cell G36 The 3 options are, INTERNATIONAL SIGNED FOR UK SIGNED FOR UK SPECIAL DELIVERY Upon the selection i would like the following to happen please. INTERNATIONAL SIGNED FOR in cell J36 enter 1 and...
  3. A

    Check if Spreadsheets in a Folder are Signed

    I do not know if this is possible but basically I would like to have the spreadsheet check a folder, then return excel file names and whether the document is signed. I've tried a few things that don't seem to work. First I wrote this code to list all files within the folder: Sub Test()...
  4. E

    Index and Match value with partial text between two dates

    I'm building an overview spreadsheet that takes information from multiple different reports. The formula I'm struggling with identifies employees by last name while all the other reports use full name (Last, First, MI), so I need to use partial text or wildcards. The report provides a row for...
    • edilly
    • Thread
    • employee index match 2 criterias overview sheet signed
    • Replies: 3
    • Forum: Excel Questions
  5. D

    VBA code to stop 2 entries not being signed off

    Hi, Please can someone help produce a code to do the following: Column I = Scan out QTY. Column J = Sign off userform triggers when there's a value in I Basically what I would like is to prevent there being 2 values in column I that haven't been signed off. I hope this makes sense and any...
  6. I

    Date Calculation (mid month)

    Hello Everyone - Looking for a formula that will calc. the start date of a contract for me given the exact date it was signed based on mid month convention. Examples If a contract is signed in the 1st 15 days of the month, then the contract start date is the 1st of that month. If a contract...
  7. M

    Best method of extracting data from large dataset

    Hi Apologies if something similar has been posted before, but I was hoping for some help with a problem I've been having with a project I'm working on. I'm working with a large dataset (approx 200,000 rows), looking at a large number of petitions (approx 10,000). which a sample of people...

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