services

  1. Q

    Comparing multiple versions of the same workbook and display results - advice

    We have a workbook with column A1:A100 containing different company names. B1:AA1 contains multiple products and services. Each company has the relevant data (versions, dates) filled in about each product or service. This could be in the form of a a number, text or date formatted cell...
  2. R

    [VBA] Cut down a string to match another string, if applicable

    Hi all, It was all going so well. In N12 I have a long string of place names, like this: Aberystwyth, Accrington, Alfreton, Altrincham, Banbury, Bangor, Barnsley, Barrow-in-Furness, Basingstoke, Bath, Bebington, Bedford, Belper, Beverley, Biggleswade, Birkenhead, Bishop Auckland, Blackburn...
  3. S

    Extracting variable length data from cell

    Would like a formula which would extract the contents between the word circuit and the second comma in a string: MPLS - MPLS Services, Circuit 2083676, Verizon, xxxx,,xxxxxxxxxxxxx , xx MPLS - MPLS Services, Circuit 572222DAT1, xxxx,xxxxx,xxxxx
  4. L

    Home Service

    Hello, Does anyone know of a good way to keep track of a Home Services business? Thanks
  5. T

    Import data from SSRS into Excel

    I can import data from SS Management Studio into Excel using VBA and ADO. Is the process the same if the data is in SS Reporting Services instead of SSMS? If not, how would I go about it? Thanks
  6. B

    How to deduct one row

    Hi All, How do you deduct 1 row from the last row selected using ctrl+shift+down? In this way, I won't be including "Grand Total" to the graph that I will be creating. Range("A5").Select Range(Selection, Selection.End(xlDown)).Select <colgroup><col width="305" style="width: 229pt...
  7. B

    Automate the creation of graph from Pivot Table - VBA

    Hi All, I have created a VBA that automatically creates a pivot table. However, I would also like to automate the creation of a graph from the the pivot table. What I want to happen is to make a graph from the details without including "Row Labels" and "Grand Total". If there is a new entry for...
  8. B

    Remove Blanks from Pivot Table VBA

    Hi All, How do you remove a row with "(blank)" from a pivot table which is also producing count for blanks? VBA <colgroup><col width="305" style="width: 229pt; mso-width-source: userset; mso-width-alt: 9760;"> <col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt...
  9. B

    Excel 2016 power query - huge data

    I connected to our oracle DB with 40million+ rows of data tied to over 110k+product. These data refers to medical services and copay info. 1product consists of 350 services/rows. To narrow it down, I created a query to pull product created 365 days prior to current date. Loaded it to the data...
  10. Y

    Enter a Value into a cell, Based on Value times that by $$ Amount to give answer

    Hi team, I'm finding what I want to do hard to articulate, however I have 10 Columns with titles of Projects, I then have 5 Rows with Services. Each service has a Dollar amount Per Service eg $220, $118 etc. I want to enter in each Column a service used each month, and rather than show the...
  11. T

    VBA for Business - Search across 2x pages with Transposing of Information

    I have a Excel document made up of 2 worksheets - one entitled "Support Register' and the other entitled 'Services' On the support register sheet, we have every client in Column B from Rows 9:120, and all our services across the top in Columns B8:ZZ8. I am attempting to make it so when I...
  12. N

    Verifying email address through VBA

    Hi, can anybody help me with task to check if email address is correct? I dont mean format, but if it bounces without sending an email. There are online services to do that for some price so it is possible to do it somehow(they were correct for my company mail, personal mail, gmail etc.). So...
  13. L

    SumProduct calculation

    So I have a convoluted calculation that I need assistance with. I am trying to calculate commission for hair stylists and additional commission for products that they sell. I have no problem with the calculation that I am using for calculating their commission. Here is an example of what I am...
  14. K

    Match multiple values, then display as a list

    Hello, I'm wondering if anyone is able to help, as this has started to take up a lot of my time, and I'm on the verge of giving up and reverting to doing it manually. I have a list "Services" which can have multiple "internal services" associated with them. I have the master list, and I...
  15. B

    Driving distance calculator

    Given that I have the mileage between motorway services, I want to be able to enter the names of any two of the services to calculate the distance between them. It must be simple but it's got me baffled.
  16. Z

    Excluding items from count if criteria is met within the same column

    Good afternoon, I apologise in advance for not knowing some terminology that may be helpful in the following request. The information I am trying to gather is formatted similar to the following: Colomn A- Customer number, Column B- list of all services the customer has. So, multiple instances...
  17. M

    Index match with multiple criteria

    Hey All- I believe I am looking for a simple index match function based on two criteria, but I must be missing something basic (typically rely on vlookups). I want to return the ticket number for a specific NPI that the Patient Services team is working on. The intent is to combine this weekly...
  18. D

    What is wrong with this code?

    Private Sub cmdNewTool_Click() Dim newDoc As String newDoc = "Anglicare Western | Clinical and Therapeutic Services Invoice" & txtyear.Value & ".xlsm" ActiveWorkbook.SaveCopyAs Filename:=newDoc It says run time error 1004, we can't find the file.
  19. K

    VBA Copy a table and Paste it upside down

    How can I write a VBA that will copy Table A and paste it as Table B (see below). Please allow for Range Selection. Thanks for your suggestions. Table A: <colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <col width="107" style="width: 80pt...
  20. E

    MS Access and SharePoint Online

    Hi I've heard that MS will stop supporting 'Access Services' in SharePoint Online but I'm not quite sure what that means. Currently I have several desktop databases linked to lists within SharePoint Online and they work quite well. Does this mean the ability to use a SharePoint list like a...

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