services

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...

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...

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

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

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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.

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...

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...