request

I am running into an issue trying to count by employee and by month, the number of weekends in time away requests that span multiple months. In one sheet "EmployeeList", I have a column with a list of all of my employees and have columns for each month of this year and next (Jan 2019 through...

Hello friends, I'm trying figure out how to place in the subject, of an email generated through Excel, just what is in column B, last row. I'm having issues with that. Here is my code below, well not all of it... but I believe you should be able to give me what I need. The subject will be...

Hello, Looking for some help on this vba code from somewhere in google, I am almost no knowledge on VBA so I'm trying to do some additional logic. so when the contract number has existing record on the 'J' column, the message will pop up and click OK, after clicking the OK button and trying to...

Hello, I have a function to validate URLs. It return as result "200" if the URL is valid and "404" if the URL is invalid. It works fine with simple URLs like: http://www.mywebsite.com/products/dresses/blue-dress But it not work properly with URLs which contain anchors (#). For this kind of...

Hi Everyone, I am looking for a formula to bring in the first two values in a row. Here is my data set: My desired outcome is the inventory during request 1 and 2 <tbody> Inventory during request 1 Inventory during request 2 12/8/2018 12/9/2018 12/10/2018 12/11/2018 12/12/2018 12/13/2018...

I would like to retrieve the Option Price last quote from Yahoo. Writing a vba code to retrieve this information from a website is far beyond my novice abilities, so I would like the kindly request from the VBA community if you could offer a vba code that would accomplish this task. The url...

I am new to CAML quering a sharepoint website. The code that I have below works great to get the data from a sharepoint website. The problem I have, the admin of the site created various custom views. And the default view is a truncated view of the data in the site. And the query gets the data...

Hello all, Could you please help me find a solution to a problem that i have in Excel? I don't know exactly if this could be achieved in Excel, so any ideea would be highly appreciated. So, i have a very big production sheet. - On column B i have the dates (in this format: 01.01.2019...

I work in a company where I raise order for customers. There's this file that has all names of customers used by SalesReps to order for the customer but from where we download, it comes with all customers both those who has request and those that don't. Now some rows of some customers don't also...

good day, I have a workbook with several worksheets, however there is a need to keep a record of repeated requests. For example. on 25/9/18 I request ID2663 to be re done, but if I do not get a response from the applicable 3rd party and have to request again. This is what I would like to see...

Can you advise if the following is possible? I have two workbooks - 1st workbooks contains the request form and the 2nd workbook contains the data I need that information selected on the request form trigger a search in the second workbook where the results are emailed to the person The...

I want to calculate the response time during working hours between two dates & times. Scenario 1: A request comes in at 10:00 on 19/9/2018 and I respond at 11:00 on same day i.e. 19/9/2018 Scenario 2: A request comes in at 11:30 on 19/9/2018 and I respond at 10:30 next day i.e. 20/9/2018...

Hello, I've been working on a new form an I'm at the point where I want to create a "Clear Form" button, which I do have working however there are certain cells that have formulas in them that I'd like to keep in there. Right now the part that is failing is in bold: Private Sub...

This is half of a formula I have..... =20-SUM(COUNTIFS('All Worker Time Off'!$C:$C,"john smith*",'All Worker Time Off'!$D:$D,”Time Off Request)) I need it to start at 20 and minus 1 for every time it finds, in the "All Worker Time Off" sheet, john smith in column $C:$C and also finds "Time...

Hi Guys! I looked everywhere and couldn't find the answer I was looking for. I need to create a macro which will send an e-mail from excel sheet. The subject should contain pre-determined text, the current date and values(numbers) from two cells. The body should have a header(range A2:L2) and a...

Hi, I have a workbook that I would like to save a copy in a particular folder with naming. I would then like to email it, and then close the file. I have used the below macro for this, however users are receiving an error on line: With Destwb .SaveAs TempFilePath & TempFileName &...

Input:C1 Mary went down the and hurt her head D1 hill Desired Output: Mary went down the hill and hurt her head Below is the best what I can describe the logic as: (If C1 contains "keyword") (Separator " ") concatenate [D1] as "[C1...Keyword][Separator][D1] [Rest of C1]" Below is the...

I would greatly appreciate VBA code to submit an API request from excel to the following URL: https://geocoding.geo.census.gov/geocoder/geogaphies/onelineaddress?address=A1+A1+A1+A1+A1=A1&benchmark=4&vintage=4&format=json&layers=8 API Response data placed below A1. Trigger to request API...

hello all, i'd like to ask anyway(formula / macro)that i can given out the best START time and END time in a range like these? <colgroup><col><col></colgroup><tbody> 09:00-14:15HH14:15-18:30CR 13:30-14:15AG14:15-21:30EE21:30-23:00DHL 09:00-18:30 ------------my request 13:30-23:00...

I'm studying for the GRE and want to make a flash card macro in excel with a list of vocab words. I found this article, but it seems dated and didn't work for me (I don't think that url works anymore). Here's what I've got so far as I try to build up to a function:Sub DefineWord() 'Assemble...