service

Hi all I have zero working knowledge of access. I am considering purchasing an access database for CRM (customer relationship management) purposes. The only drawback is that this would sit on my desktop and for obvious reasons I am hesitant. Is there a service or somewhat simple way for me to...

Hello everyone, I'm not good at excel but i've been given the task of making a spreadsheet for fleet inventory(trucks/trailers,etc) I have a main sheet (Main Board) which lists all vehicles by Type and Number. I have 3 sections (Notices) to the right , which shows vehicles out of service...

I have a field in my dBase that contains the Active Directory Distinguished Name, that I need to filter on to separate account types. The data string in the field will look like this for a user account: CN=Lapp\, Lawrence E. (Larry) (TUC) ISSO,OU=Users,OU=Tucson...

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

Have an extracted text file that was imported into Excel. This is the exact format subsequent to import: <tbody> RVICE TY PE : TP SU SP ENSE TYPE : I AA REASON : Invalid Service Traffic Stream T139914 1/12/2016 9:53 I 5578457844 7878515342 ST LUCIA 20:00 TP DD C8 I= O=...

Hi Everyone! I am attempting to develop what at first seemed to be a simple scheduling aid in excel 2016 – but can’t seem to find a way to populate a single dropdown list with a conditioned list based on a of range variables on different sheets in the workbook. The first and primary sheet...

In a service, below 3 months of service will not be counted. Three or more than three months of service will be counted as next 6 months qualifying service.How will i calculate it in excel? For example: 15 years 2 (<3) months to be calculated as 15 years. 15 years 3/4/6/7/8...

folks, i am trying to match and compare two data sets to ensure we are charging the correct amount. One contains the rates charged for medical procedures (Rates) and the associated service fee charged for ancillary items, and the other contains patient level data (Patients) including fees and...

Hi Guys, I'm struggling how to add some additional code to the below. Essentially, if the formula in Allocate!e16 is equal to blank, then do nothing, else run the below: The formula is Allocate!e16 is =IF(E16<>0, D16, "") Sub Payam_Naeini_New_Calls_Service_and_MOT()'Payam Naeini...

Hi Guys, Just wondering if there is a way to turn the below 3 codes into one. I have 15 of these in total (3 is just for example purposes). The code essentially filters based on 3 columns, selects the number of rows based on a cell in the 'Allocate' tab and then copies to the 'All Data' Tab...

<colgroup><col span="3"><col><col></colgroup><tbody> ColumnA ColumnB ColumnC ColumnD Code User Role Hours PM Ram Service 5 Dev Satish DBA 9 Internal John Service 99 Arch Mary SR Cons 22 Internal Mary SR Cons 8 Arch xxx SR Cons 9 Arch yyy Cons 8 My...

Hello, I have this code to put data on the 'Service Log'! sheet. I want to keep that sheet protected but the code won't run unless I keep the sheet unprotected. Can there be lines added so it will unprotect the 'Service Log'! and protect again please? Thank you Sub CopyPasteRows1()...

Hey everyone! I am pulling out my hair and finally decided I just needed to ask for help somewhere. Apparently, I know just enough to be dangerous... :laugh: I am creating a dashboard with multiple locations that I need to roll up into one summary page. Each location is on a separate worksheet...

Hi everyone. I have been trying to help myself as much as I can, however, I have spent too much time on this and now I am rushing to get it done which is making it worse. What I am trying to accomplish is to be able to enter/select a category which will limit the service list to the items...

Hello, I have this code that will update the appropriate vehicle when the selected service is entered. How it works now is one service is entered at a time. On most occasions it would be better to be able to select multiple services. Does anyone have ideas on how to perhaps have the list of...

Hello, I conducted a survey on people's emotional well-being after they had received a emotional counselling service. I asked respondents 5 separate questions on how effective the counselling service was with 7 response options: - Strongly agree - Agree - Neither agree or disagree - Disagree -...

Hi all, I'm hoping someone could help me with a formula or perhaps a VLOOKUP. I've been trying different things and can't seem to get where I need to be. What I have is Sheet A with Contacts. Each Contact is associated with a Service Contract on Sheet A. On a second Sheet B, I have a list...

Guys I need help. I run a code on VBA in my work , and on some pc i could run it and on other i couldnt. I read some answers for that error and they said that maybe its service pack for windows i check it and it wasnt . Can someone help me? Thank you

I am trying to have a formula that calculates time in service based on hire date and todays date and then giving the amount of leave hours per pay period. 0-4yeas = 4hours 5-9years = 5 hours 10+= 6 hours

https://drive.google.com/open?id=1eqtXSg4kU9vIpss9uc6VUs6mVnzVHHDmStruggling to figure out accurate formulas to return the results I'm looking for. I have attached a spreadsheet for review. I want this data to provide three values in G4, H4, & I4: 1) The total # of DA's in column C... I'm...