complaint

  1. D

    match customer and date of service to another spreadsheet that has customer and check-in / check-out date range

    I have a file that has customer # and date a complaint was made and another log spreadsheet that has customer # and check-in and check-out date. Not all customers will have filed a complaint in the date of service file. Is there a way to flag the log file when the customer numbers match and...
  2. C

    Clear a cell if duplicate VBA

    Please forgive my stupidity......I am trying to put forth the effort. Ok, I got this code to find a duplicate on another page, but what I have written doesnt work to clear the cell after it learned it was a duplicate. hear is my novice code. Sub askcompnum() Title = InputBox("Enter a...
  3. B

    How to highlight a specific cell based on value/text/number

    Hi guys, First of all, please try to forgive me for my bad English as it's not my native language. You see, I have this excel training spreadsheet where I want to do the following: 1. Highlight both cells (Non-compliant & Complaint columns) with a specific colour (let's just say pink) if...
  4. G

    search and Load a Userform issue

    Good Morning, The code below loads the data into my userform with no issue, but I need to load the userform and have the combobox1 options load also straight away instead of basing the combobox1 data on a change of the userform once its loaded. I am confused on how to get this to work? Should...
  5. R

    Is it possible ?

    good evening all. I wonder if it is possible. I have a customer complaint sheet with a list of complaint reasons. I then fill in complaint with date, reason and various other info. at the top of the sheet I have the months of the year and I want to populate how many times during a given month...
  6. G

    VBA working to send an email, doesnt error but doesnt send

    Good Afternoon, With help from people on here and Google I have created VBA to issue an email based on a form that is completed. The VBA runs (stepped through) with no errors but doesnt send anything via Office. I am using Excel 2016 I think, but I am missing something but I am unsure what it...
  7. G

    Email body via VBA

    Good Afternoon, I am able to email info from a range in a sheet from a copy and paste point, but I would like to make the email more readable. I have looked on line, but am having a bit of trouble with this The code below puts all the information in the email but I would like to space this...

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